View: PAY_KR_SEP_MASTER_EE_V

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

View Text

SELECT PEE.ASSIGNMENT_ID ASSIGNMENT_ID
, PEE.ELEMENT_ENTRY_ID ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PEE.CREATOR_ID CREATOR_ID
, PEE.CREATOR_TYPE CREATOR_TYPE
, PEE.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PET.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, PET.EFFECTIVE_START_DATE TEFFECTIVE_START_DATE
, PET.EFFECTIVE_END_DATE TEFFECTIVE_END_DATE
, PET.ELEMENT_NAME ELEMENT_NAME
, PET.PROCESSING_PRIORITY PROCESSING_PRIORITY
, PETTL.ELEMENT_NAME UELEMENT_NAME
, PEL.ELEMENT_LINK_ID ELEMENT_LINK_ID
, PEL.EFFECTIVE_START_DATE LEFFECTIVE_START_DATE
, PEL.EFFECTIVE_END_DATE LEFFECTIVE_END_DATE
, PEC.CLASSIFICATION_ID CLASSIFICATION_ID
, PEC.CLASSIFICATION_NAME CLASSIFICATION_NAME
, PECTL.CLASSIFICATION_NAME UCLASSIFICATION_NAME
FROM PAY_ELEMENT_CLASSIFICATIONS_TL PECTL
, PAY_ELEMENT_CLASSIFICATIONS PEC
, PAY_ELEMENT_TYPES_F_TL PETTL
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_ENTRIES_F PEE
, FND_SESSIONS FS
WHERE FS.SESSION_ID = USERENV('SESSIONID')
AND PEE.CREATOR_TYPE IN ('F'
, 'H')
AND PEC.LEGISLATION_CODE = 'KR'
AND FS.EFFECTIVE_DATE BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND PEL.ELEMENT_LINK_ID = PEE.ELEMENT_LINK_ID
AND FS.EFFECTIVE_DATE BETWEEN PEL.EFFECTIVE_START_DATE
AND PEL.EFFECTIVE_END_DATE
AND PET.ELEMENT_TYPE_ID = PEL.ELEMENT_TYPE_ID
AND FS.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PETTL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE = USERENV('LANG')
AND PEC.CLASSIFICATION_ID = PET.CLASSIFICATION_ID
AND PECTL.CLASSIFICATION_ID = PEC.CLASSIFICATION_ID
AND PECTL.LANGUAGE = USERENV('LANG')
AND NOT EXISTS ( SELECT NULL
FROM PAY_RUN_TYPES_F PRT_SEP
, PAY_RUN_TYPES_F PRT_SEPI
, PAY_ELEMENT_TYPE_USAGES_F PETU_SEP
, PAY_ELEMENT_TYPE_USAGES_F PETU_SEPI
WHERE PETU_SEP.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PETU_SEPI.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND FS.EFFECTIVE_DATE BETWEEN PETU_SEP.EFFECTIVE_START_DATE
AND PETU_SEP.EFFECTIVE_END_DATE
AND FS.EFFECTIVE_DATE BETWEEN PETU_SEPI.EFFECTIVE_START_DATE
AND PETU_SEPI.EFFECTIVE_END_DATE
AND NVL(PETU_SEP.INCLUSION_FLAG
, 'N') = 'N'
AND NVL(PETU_SEPI.INCLUSION_FLAG
, 'N') = 'N'
AND PRT_SEP.RUN_TYPE_ID = PETU_SEP.RUN_TYPE_ID
AND PRT_SEPI.RUN_TYPE_ID = PETU_SEPI.RUN_TYPE_ID
AND FS.EFFECTIVE_DATE BETWEEN PRT_SEP.EFFECTIVE_START_DATE
AND PRT_SEP.EFFECTIVE_END_DATE
AND FS.EFFECTIVE_DATE BETWEEN PRT_SEPI.EFFECTIVE_START_DATE
AND PRT_SEPI.EFFECTIVE_END_DATE
AND PRT_SEP.RUN_TYPE_NAME IN ('SEP')
AND PRT_SEPI.RUN_TYPE_NAME IN ('SEP_I') )

Columns