2014-06-20 09:28:39 【 INFO】 
					 /* 予約グループを取得する(予約無し枠を除く) */
					SELECT
						CODE,
						NAME
					FROM
						ITEM_YOYAKU
					WHERE
							CONDITION_FLG = 0
						AND	MASTER_CODE_STR = '00810006'
						AND SECTION_CODE = :B_SECTION_CODE          --予約診療科
						AND	SUBSTR(DISP_FLGTBL, 6, 1) != '1'
					ORDER BY
						GROUP_CODE
2014-06-20 09:34:05 【 INFO】 
					 /* 予約グループを取得する(予約無し枠を除く) */
					SELECT
						CODE,
						NAME
					FROM
						ITEM_YOYAKU
					WHERE
							CONDITION_FLG = 0
						AND	MASTER_CODE_STR = '00810006'
						AND SECTION_CODE = :B_SECTION_CODE          --予約診療科
						AND	SUBSTR(DISP_FLGTBL, 6, 1) != '1'
					ORDER BY
						GROUP_CODE
2014-06-20 09:34:13 【 INFO】 
					 /* 予約グループを取得する(予約無し枠を除く) */
					SELECT
						CODE,
						NAME
					FROM
						ITEM_YOYAKU
					WHERE
							CONDITION_FLG = 0
						AND	MASTER_CODE_STR = '00810006'
						AND SECTION_CODE = :B_SECTION_CODE          --予約診療科
						AND	SUBSTR(DISP_FLGTBL, 6, 1) != '1'
					ORDER BY
						GROUP_CODE
2014-06-20 13:20:59 【 INFO】 
				SELECT
					CODE,
					NAME
				FROM
					IRAI_KENTAI
				WHERE
					CONDITION_FLG = :B_CONDITION_FLG
					AND LAST_FLG = :B_LAST_FLG
			AND NAME LIKE '%' || :B_NAME || '%' ORDER BY DISP_ORDER 
2014-06-20 13:21:00 【 INFO】 
				SELECT
					CODE,
					NAME
				FROM
					IRAI_KENTAI
				WHERE
					CONDITION_FLG = :B_CONDITION_FLG
					AND LAST_FLG = :B_LAST_FLG
			AND NAME LIKE '%' || :B_NAME || '%' ORDER BY DISP_ORDER 
2014-06-20 13:21:08 【 INFO】 
				SELECT
					CODE,
					NAME
				FROM
					IRAI_KENTAI
				WHERE
					CONDITION_FLG = :B_CONDITION_FLG
					AND LAST_FLG = :B_LAST_FLG
			AND NAME LIKE '%' || :B_NAME || '%' ORDER BY DISP_ORDER 
2014-06-20 13:21:10 【 INFO】 
				SELECT
					CODE,
					NAME
				FROM
					IRAI_KENTAI
				WHERE
					CONDITION_FLG = :B_CONDITION_FLG
					AND LAST_FLG = :B_LAST_FLG
			AND NAME LIKE '%' || :B_NAME || '%' ORDER BY DISP_ORDER 
2014-06-20 13:21:20 【 INFO】 
				SELECT
					CODE,
					NAME
				FROM
					IRAI_KENTAI
				WHERE
					CONDITION_FLG = :B_CONDITION_FLG
					AND LAST_FLG = :B_LAST_FLG
			AND NAME LIKE '%' || :B_NAME || '%' ORDER BY DISP_ORDER 
2014-06-20 13:21:45 【 INFO】 
				SELECT
					CODE,
					NAME
				FROM
					KOUI_SHOCHI
				WHERE
					CONDITION_FLG = :B_CONDITION_FLG
					AND LAST_FLG = :B_LAST_FLG
			AND NAME LIKE '%' || :B_NAME || '%' ORDER BY DISP_ORDER 
2014-06-20 13:22:18 【 INFO】 
				SELECT
					CODE,
					NAME
				FROM
					IRAI_KENTAI
				WHERE
					CONDITION_FLG = :B_CONDITION_FLG
					AND LAST_FLG = :B_LAST_FLG
			AND NAME LIKE '%' || :B_NAME || '%' ORDER BY DISP_ORDER 
2014-06-20 13:22:26 【 INFO】 
				SELECT
					CODE,
					NAME
				FROM
					IRAI_KENTAI
				WHERE
					CONDITION_FLG = :B_CONDITION_FLG
					AND LAST_FLG = :B_LAST_FLG
			AND NAME LIKE '%' || :B_NAME || '%' ORDER BY DISP_ORDER