View: PAY_KR_SEP_MASTER_EEV_V

Product:	PAY - Payroll
Description:	This view returns element entry value which are relevant with Separation Pay Process based on element_entry_id.
Implementation/DBA Data:	APPS.PAY_KR_SEP_MASTER_EEV_V

View Text

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

Columns