VIEW: APPS.PAY_KR_SEP_MASTER_EEV_V

Source

View Text - Preformatted

SELECT pee.element_entry_id element_entry_id, pee.effective_start_date effective_start_date, pee.effective_end_date effective_end_date, pee.object_version_number object_version_number, pel.element_link_id lelement_link_id, pel.effective_start_date leffective_start_date, pel.effective_end_date leffective_end_date, pet.element_type_id telement_type_id, pet.effective_start_date teffective_start_date, pet.effective_end_date teffective_end_date, pay_kr_sep_form_pkg.get_input_value_id(pet.element_type_id,1,pel.business_group_id) input_value_id1, pay_kr_sep_form_pkg.get_input_value_id(pet.element_type_id,2,pel.business_group_id) input_value_id2, pay_kr_sep_form_pkg.get_input_value_id(pet.element_type_id,3,pel.business_group_id) input_value_id3, pay_kr_sep_form_pkg.get_input_value_id(pet.element_type_id,4,pel.business_group_id) input_value_id4, pay_kr_sep_form_pkg.get_input_value_id(pet.element_type_id,5,pel.business_group_id) input_value_id5, pay_kr_sep_form_pkg.get_input_value_id(pet.element_type_id,6,pel.business_group_id) input_value_id6, pay_kr_sep_form_pkg.get_input_value_id(pet.element_type_id,7,pel.business_group_id) input_value_id7, pay_kr_sep_form_pkg.get_input_value_id(pet.element_type_id,8,pel.business_group_id) input_value_id8, pay_kr_sep_form_pkg.get_input_value_id(pet.element_type_id,9,pel.business_group_id) input_value_id9, pay_kr_sep_form_pkg.get_input_value_id(pet.element_type_id,10,pel.business_group_id) input_value_id10, pay_kr_sep_form_pkg.get_input_value_id(pet.element_type_id,11,pel.business_group_id) input_value_id11, pay_kr_sep_form_pkg.get_input_value_id(pet.element_type_id,12,pel.business_group_id) input_value_id12, pay_kr_sep_form_pkg.get_input_value_id(pet.element_type_id,13,pel.business_group_id) input_value_id13, pay_kr_sep_form_pkg.get_input_value_id(pet.element_type_id,14,pel.business_group_id) input_value_id14, pay_kr_sep_form_pkg.get_input_value_id(pet.element_type_id,15,pel.business_group_id) input_value_id15, pay_kr_sep_form_pkg.get_input_value_name(pet.element_type_id,1,pel.business_group_id) input_value_name1, pay_kr_sep_form_pkg.get_input_value_name(pet.element_type_id,2,pel.business_group_id) input_value_name2, pay_kr_sep_form_pkg.get_input_value_name(pet.element_type_id,3,pel.business_group_id) input_value_name3, pay_kr_sep_form_pkg.get_input_value_name(pet.element_type_id,4,pel.business_group_id) input_value_name4, pay_kr_sep_form_pkg.get_input_value_name(pet.element_type_id,5,pel.business_group_id) input_value_name5, pay_kr_sep_form_pkg.get_input_value_name(pet.element_type_id,6,pel.business_group_id) input_value_name6, pay_kr_sep_form_pkg.get_input_value_name(pet.element_type_id,7,pel.business_group_id) input_value_name7, pay_kr_sep_form_pkg.get_input_value_name(pet.element_type_id,8,pel.business_group_id) input_value_name8, pay_kr_sep_form_pkg.get_input_value_name(pet.element_type_id,9,pel.business_group_id) input_value_name9, pay_kr_sep_form_pkg.get_input_value_name(pet.element_type_id,10,pel.business_group_id) input_value_name10, pay_kr_sep_form_pkg.get_input_value_name(pet.element_type_id,11,pel.business_group_id) input_value_name11, pay_kr_sep_form_pkg.get_input_value_name(pet.element_type_id,12,pel.business_group_id) input_value_name12, pay_kr_sep_form_pkg.get_input_value_name(pet.element_type_id,13,pel.business_group_id) input_value_name13, pay_kr_sep_form_pkg.get_input_value_name(pet.element_type_id,14,pel.business_group_id) input_value_name14, pay_kr_sep_form_pkg.get_input_value_name(pet.element_type_id,15,pel.business_group_id) input_value_name15, pay_kr_sep_form_pkg.get_input_value_d_sequence(pet.element_type_id,1,pel.business_group_id) display_sequence1, pay_kr_sep_form_pkg.get_input_value_d_sequence(pet.element_type_id,2,pel.business_group_id) display_sequence2, pay_kr_sep_form_pkg.get_input_value_d_sequence(pet.element_type_id,3,pel.business_group_id) display_sequence3, pay_kr_sep_form_pkg.get_input_value_d_sequence(pet.element_type_id,4,pel.business_group_id) display_sequence4, pay_kr_sep_form_pkg.get_input_value_d_sequence(pet.element_type_id,5,pel.business_group_id) display_sequence5, pay_kr_sep_form_pkg.get_input_value_d_sequence(pet.element_type_id,6,pel.business_group_id) display_sequence6, pay_kr_sep_form_pkg.get_input_value_d_sequence(pet.element_type_id,7,pel.business_group_id) display_sequence7, pay_kr_sep_form_pkg.get_input_value_d_sequence(pet.element_type_id,8,pel.business_group_id) display_sequence8, pay_kr_sep_form_pkg.get_input_value_d_sequence(pet.element_type_id,9,pel.business_group_id) display_sequence9, pay_kr_sep_form_pkg.get_input_value_d_sequence(pet.element_type_id,10,pel.business_group_id) display_sequence10, pay_kr_sep_form_pkg.get_input_value_d_sequence(pet.element_type_id,11,pel.business_group_id) display_sequence11, pay_kr_sep_form_pkg.get_input_value_d_sequence(pet.element_type_id,12,pel.business_group_id) display_sequence12, pay_kr_sep_form_pkg.get_input_value_d_sequence(pet.element_type_id,13,pel.business_group_id) display_sequence13, pay_kr_sep_form_pkg.get_input_value_d_sequence(pet.element_type_id,14,pel.business_group_id) display_sequence14, pay_kr_sep_form_pkg.get_input_value_d_sequence(pet.element_type_id,15,pel.business_group_id) display_sequence15, pay_kr_sep_form_pkg.get_screen_entry_value(pet.element_type_id,1,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date) screen_entry_value1, pay_kr_sep_form_pkg.get_screen_entry_value(pet.element_type_id,2,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date) screen_entry_value2, pay_kr_sep_form_pkg.get_screen_entry_value(pet.element_type_id,3,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date) screen_entry_value3, pay_kr_sep_form_pkg.get_screen_entry_value(pet.element_type_id,4,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date) screen_entry_value4, pay_kr_sep_form_pkg.get_screen_entry_value(pet.element_type_id,5,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date) screen_entry_value5, pay_kr_sep_form_pkg.get_screen_entry_value(pet.element_type_id,6,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date) screen_entry_value6, pay_kr_sep_form_pkg.get_screen_entry_value(pet.element_type_id,7,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date) screen_entry_value7, pay_kr_sep_form_pkg.get_screen_entry_value(pet.element_type_id,8,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date) screen_entry_value8, pay_kr_sep_form_pkg.get_screen_entry_value(pet.element_type_id,9,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date) screen_entry_value9, pay_kr_sep_form_pkg.get_screen_entry_value(pet.element_type_id,10,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date) screen_entry_value10, pay_kr_sep_form_pkg.get_screen_entry_value(pet.element_type_id,11,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date) screen_entry_value11, pay_kr_sep_form_pkg.get_screen_entry_value(pet.element_type_id,12,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date) screen_entry_value12, pay_kr_sep_form_pkg.get_screen_entry_value(pet.element_type_id,13,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date) screen_entry_value13, pay_kr_sep_form_pkg.get_screen_entry_value(pet.element_type_id,14,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date) screen_entry_value14, pay_kr_sep_form_pkg.get_screen_entry_value(pet.element_type_id,15,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date) screen_entry_value15, pay_kr_sep_form_pkg.get_entry_value(pet.element_type_id,1,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date,pel.element_link_id) entry_value1, pay_kr_sep_form_pkg.get_entry_value(pet.element_type_id,2,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date,pel.element_link_id) entry_value2, pay_kr_sep_form_pkg.get_entry_value(pet.element_type_id,3,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date,pel.element_link_id) entry_value3, pay_kr_sep_form_pkg.get_entry_value(pet.element_type_id,4,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date,pel.element_link_id) entry_value4, pay_kr_sep_form_pkg.get_entry_value(pet.element_type_id,5,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date,pel.element_link_id) entry_value5, pay_kr_sep_form_pkg.get_entry_value(pet.element_type_id,6,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date,pel.element_link_id) entry_value6, pay_kr_sep_form_pkg.get_entry_value(pet.element_type_id,7,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date,pel.element_link_id) entry_value7, pay_kr_sep_form_pkg.get_entry_value(pet.element_type_id,8,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date,pel.element_link_id) entry_value8, pay_kr_sep_form_pkg.get_entry_value(pet.element_type_id,9,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date,pel.element_link_id) entry_value9, pay_kr_sep_form_pkg.get_entry_value(pet.element_type_id,10,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date,pel.element_link_id) entry_value10, pay_kr_sep_form_pkg.get_entry_value(pet.element_type_id,11,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date,pel.element_link_id) entry_value11, pay_kr_sep_form_pkg.get_entry_value(pet.element_type_id,12,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date,pel.element_link_id) entry_value12, pay_kr_sep_form_pkg.get_entry_value(pet.element_type_id,13,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date,pel.element_link_id) entry_value13, pay_kr_sep_form_pkg.get_entry_value(pet.element_type_id,14,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date,pel.element_link_id) entry_value14, pay_kr_sep_form_pkg.get_entry_value(pet.element_type_id,15,pel.business_group_id,pee.element_entry_id,pee.effective_start_date,pee.effective_end_date,pel.element_link_id) entry_value15 from pay_element_types_f pet, pay_element_links_f pel, pay_element_entries_f pee where pel.element_link_id = pee.element_link_id and pet.element_type_id = pel.element_type_id

View Text - HTML Formatted

SELECT PEE.ELEMENT_ENTRY_ID ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PEE.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PEL.ELEMENT_LINK_ID LELEMENT_LINK_ID
, PEL.EFFECTIVE_START_DATE LEFFECTIVE_START_DATE
, PEL.EFFECTIVE_END_DATE LEFFECTIVE_END_DATE
, PET.ELEMENT_TYPE_ID TELEMENT_TYPE_ID
, PET.EFFECTIVE_START_DATE TEFFECTIVE_START_DATE
, PET.EFFECTIVE_END_DATE TEFFECTIVE_END_DATE
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_ID(PET.ELEMENT_TYPE_ID
, 1
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_ID1
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_ID(PET.ELEMENT_TYPE_ID
, 2
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_ID2
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_ID(PET.ELEMENT_TYPE_ID
, 3
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_ID3
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_ID(PET.ELEMENT_TYPE_ID
, 4
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_ID4
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_ID(PET.ELEMENT_TYPE_ID
, 5
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_ID5
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_ID(PET.ELEMENT_TYPE_ID
, 6
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_ID6
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_ID(PET.ELEMENT_TYPE_ID
, 7
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_ID7
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_ID(PET.ELEMENT_TYPE_ID
, 8
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_ID8
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_ID(PET.ELEMENT_TYPE_ID
, 9
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_ID9
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_ID(PET.ELEMENT_TYPE_ID
, 10
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_ID10
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_ID(PET.ELEMENT_TYPE_ID
, 11
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_ID11
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_ID(PET.ELEMENT_TYPE_ID
, 12
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_ID12
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_ID(PET.ELEMENT_TYPE_ID
, 13
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_ID13
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_ID(PET.ELEMENT_TYPE_ID
, 14
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_ID14
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_ID(PET.ELEMENT_TYPE_ID
, 15
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_ID15
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_NAME(PET.ELEMENT_TYPE_ID
, 1
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_NAME1
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_NAME(PET.ELEMENT_TYPE_ID
, 2
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_NAME2
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_NAME(PET.ELEMENT_TYPE_ID
, 3
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_NAME3
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_NAME(PET.ELEMENT_TYPE_ID
, 4
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_NAME4
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_NAME(PET.ELEMENT_TYPE_ID
, 5
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_NAME5
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_NAME(PET.ELEMENT_TYPE_ID
, 6
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_NAME6
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_NAME(PET.ELEMENT_TYPE_ID
, 7
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_NAME7
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_NAME(PET.ELEMENT_TYPE_ID
, 8
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_NAME8
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_NAME(PET.ELEMENT_TYPE_ID
, 9
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_NAME9
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_NAME(PET.ELEMENT_TYPE_ID
, 10
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_NAME10
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_NAME(PET.ELEMENT_TYPE_ID
, 11
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_NAME11
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_NAME(PET.ELEMENT_TYPE_ID
, 12
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_NAME12
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_NAME(PET.ELEMENT_TYPE_ID
, 13
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_NAME13
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_NAME(PET.ELEMENT_TYPE_ID
, 14
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_NAME14
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_NAME(PET.ELEMENT_TYPE_ID
, 15
, PEL.BUSINESS_GROUP_ID) INPUT_VALUE_NAME15
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_D_SEQUENCE(PET.ELEMENT_TYPE_ID
, 1
, PEL.BUSINESS_GROUP_ID) DISPLAY_SEQUENCE1
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_D_SEQUENCE(PET.ELEMENT_TYPE_ID
, 2
, PEL.BUSINESS_GROUP_ID) DISPLAY_SEQUENCE2
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_D_SEQUENCE(PET.ELEMENT_TYPE_ID
, 3
, PEL.BUSINESS_GROUP_ID) DISPLAY_SEQUENCE3
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_D_SEQUENCE(PET.ELEMENT_TYPE_ID
, 4
, PEL.BUSINESS_GROUP_ID) DISPLAY_SEQUENCE4
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_D_SEQUENCE(PET.ELEMENT_TYPE_ID
, 5
, PEL.BUSINESS_GROUP_ID) DISPLAY_SEQUENCE5
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_D_SEQUENCE(PET.ELEMENT_TYPE_ID
, 6
, PEL.BUSINESS_GROUP_ID) DISPLAY_SEQUENCE6
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_D_SEQUENCE(PET.ELEMENT_TYPE_ID
, 7
, PEL.BUSINESS_GROUP_ID) DISPLAY_SEQUENCE7
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_D_SEQUENCE(PET.ELEMENT_TYPE_ID
, 8
, PEL.BUSINESS_GROUP_ID) DISPLAY_SEQUENCE8
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_D_SEQUENCE(PET.ELEMENT_TYPE_ID
, 9
, PEL.BUSINESS_GROUP_ID) DISPLAY_SEQUENCE9
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_D_SEQUENCE(PET.ELEMENT_TYPE_ID
, 10
, PEL.BUSINESS_GROUP_ID) DISPLAY_SEQUENCE10
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_D_SEQUENCE(PET.ELEMENT_TYPE_ID
, 11
, PEL.BUSINESS_GROUP_ID) DISPLAY_SEQUENCE11
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_D_SEQUENCE(PET.ELEMENT_TYPE_ID
, 12
, PEL.BUSINESS_GROUP_ID) DISPLAY_SEQUENCE12
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_D_SEQUENCE(PET.ELEMENT_TYPE_ID
, 13
, PEL.BUSINESS_GROUP_ID) DISPLAY_SEQUENCE13
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_D_SEQUENCE(PET.ELEMENT_TYPE_ID
, 14
, PEL.BUSINESS_GROUP_ID) DISPLAY_SEQUENCE14
, PAY_KR_SEP_FORM_PKG.GET_INPUT_VALUE_D_SEQUENCE(PET.ELEMENT_TYPE_ID
, 15
, PEL.BUSINESS_GROUP_ID) DISPLAY_SEQUENCE15
, PAY_KR_SEP_FORM_PKG.GET_SCREEN_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 1
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) SCREEN_ENTRY_VALUE1
, PAY_KR_SEP_FORM_PKG.GET_SCREEN_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 2
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) SCREEN_ENTRY_VALUE2
, PAY_KR_SEP_FORM_PKG.GET_SCREEN_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 3
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) SCREEN_ENTRY_VALUE3
, PAY_KR_SEP_FORM_PKG.GET_SCREEN_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 4
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) SCREEN_ENTRY_VALUE4
, PAY_KR_SEP_FORM_PKG.GET_SCREEN_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 5
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) SCREEN_ENTRY_VALUE5
, PAY_KR_SEP_FORM_PKG.GET_SCREEN_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 6
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) SCREEN_ENTRY_VALUE6
, PAY_KR_SEP_FORM_PKG.GET_SCREEN_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 7
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) SCREEN_ENTRY_VALUE7
, PAY_KR_SEP_FORM_PKG.GET_SCREEN_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 8
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) SCREEN_ENTRY_VALUE8
, PAY_KR_SEP_FORM_PKG.GET_SCREEN_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 9
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) SCREEN_ENTRY_VALUE9
, PAY_KR_SEP_FORM_PKG.GET_SCREEN_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 10
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) SCREEN_ENTRY_VALUE10
, PAY_KR_SEP_FORM_PKG.GET_SCREEN_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 11
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) SCREEN_ENTRY_VALUE11
, PAY_KR_SEP_FORM_PKG.GET_SCREEN_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 12
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) SCREEN_ENTRY_VALUE12
, PAY_KR_SEP_FORM_PKG.GET_SCREEN_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 13
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) SCREEN_ENTRY_VALUE13
, PAY_KR_SEP_FORM_PKG.GET_SCREEN_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 14
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) SCREEN_ENTRY_VALUE14
, PAY_KR_SEP_FORM_PKG.GET_SCREEN_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 15
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) SCREEN_ENTRY_VALUE15
, PAY_KR_SEP_FORM_PKG.GET_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 1
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEL.ELEMENT_LINK_ID) ENTRY_VALUE1
, PAY_KR_SEP_FORM_PKG.GET_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 2
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEL.ELEMENT_LINK_ID) ENTRY_VALUE2
, PAY_KR_SEP_FORM_PKG.GET_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 3
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEL.ELEMENT_LINK_ID) ENTRY_VALUE3
, PAY_KR_SEP_FORM_PKG.GET_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 4
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEL.ELEMENT_LINK_ID) ENTRY_VALUE4
, PAY_KR_SEP_FORM_PKG.GET_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 5
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEL.ELEMENT_LINK_ID) ENTRY_VALUE5
, PAY_KR_SEP_FORM_PKG.GET_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 6
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEL.ELEMENT_LINK_ID) ENTRY_VALUE6
, PAY_KR_SEP_FORM_PKG.GET_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 7
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEL.ELEMENT_LINK_ID) ENTRY_VALUE7
, PAY_KR_SEP_FORM_PKG.GET_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 8
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEL.ELEMENT_LINK_ID) ENTRY_VALUE8
, PAY_KR_SEP_FORM_PKG.GET_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 9
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEL.ELEMENT_LINK_ID) ENTRY_VALUE9
, PAY_KR_SEP_FORM_PKG.GET_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 10
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEL.ELEMENT_LINK_ID) ENTRY_VALUE10
, PAY_KR_SEP_FORM_PKG.GET_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 11
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEL.ELEMENT_LINK_ID) ENTRY_VALUE11
, PAY_KR_SEP_FORM_PKG.GET_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 12
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEL.ELEMENT_LINK_ID) ENTRY_VALUE12
, PAY_KR_SEP_FORM_PKG.GET_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 13
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEL.ELEMENT_LINK_ID) ENTRY_VALUE13
, PAY_KR_SEP_FORM_PKG.GET_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 14
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEL.ELEMENT_LINK_ID) ENTRY_VALUE14
, PAY_KR_SEP_FORM_PKG.GET_ENTRY_VALUE(PET.ELEMENT_TYPE_ID
, 15
, PEL.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEL.ELEMENT_LINK_ID) ENTRY_VALUE15
FROM PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_ENTRIES_F PEE
WHERE PEL.ELEMENT_LINK_ID = PEE.ELEMENT_LINK_ID
AND PET.ELEMENT_TYPE_ID = PEL.ELEMENT_TYPE_ID