View: PAY_KR_SEP_RESULT_EE_V

Product:	PAY - Payroll
Description:	This view returns Entry of Separation Pay Process based on assignment_action_id.
Implementation/DBA Data:	APPS.PAY_KR_SEP_RESULT_EE_V

View Text

SELECT PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE EFFECTIVE_DATE
, PPA.DATE_EARNED DATE_EARNED
, PAA.RUN_TYPE_ID RUN_TYPE_ID
, PEL.ELEMENT_LINK_ID ELEMENT_LINK_ID
, PEE.ELEMENT_ENTRY_ID ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PEE.ENTRY_TYPE ENTRY_TYPE
, PEE.CREATOR_TYPE CREATOR_TYPE
, PEE.CREATOR_ID CREATOR_ID
, PEE.SOURCE_ID SOURCE_ID
, PET.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, PET.ELEMENT_NAME ELEMENT_NAME
, PET.PROCESSING_PRIORITY PROCESSING_PRIORITY
, PETL.ELEMENT_NAME UELEMENT_NAME
, 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 PETL
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE NOT EXISTS( SELECT NULL
FROM PAY_RUN_TYPES_F PRT
, PAY_PAYROLL_ACTIONS SPPA
, PAY_ASSIGNMENT_ACTIONS SPAA
, PAY_ACTION_INTERLOCKS PAI
WHERE PAI.LOCKING_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND SPAA.ASSIGNMENT_ACTION_ID = PAI.LOCKED_ACTION_ID
AND SPPA.PAYROLL_ACTION_ID = SPAA.PAYROLL_ACTION_ID
AND PRT.RUN_TYPE_ID = SPAA.RUN_TYPE_ID
AND SPPA.EFFECTIVE_DATE BETWEEN PRT.EFFECTIVE_START_DATE
AND PRT.EFFECTIVE_END_DATE
AND PRT.RUN_TYPE_NAME LIKE 'SEP%')
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PEE.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PPA.DATE_EARNED BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND PEE.CREATOR_TYPE IN ('B'
, 'EE'
, 'F'
, 'H'
, 'R'
, 'RR')
AND PEL.ELEMENT_LINK_ID = PEE.ELEMENT_LINK_ID
AND PPA.DATE_EARNED BETWEEN PEL.EFFECTIVE_START_DATE
AND PEL.EFFECTIVE_END_DATE
AND PET.ELEMENT_TYPE_ID = PEL.ELEMENT_TYPE_ID
AND PPA.DATE_EARNED BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PETL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PETL.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
, PAY_ELEMENT_TYPE_USAGES_F PETU
WHERE PETU.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PPA.EFFECTIVE_DATE BETWEEN PETU.EFFECTIVE_START_DATE
AND PETU.EFFECTIVE_END_DATE
AND PETU.INCLUSION_FLAG = 'N'
AND PRT.RUN_TYPE_ID = PETU.RUN_TYPE_ID
AND PPA.EFFECTIVE_DATE BETWEEN PRT.EFFECTIVE_START_DATE
AND PRT.EFFECTIVE_END_DATE
AND PRT.RUN_TYPE_NAME LIKE 'SEP%')
AND NOT EXISTS( SELECT NULL
FROM PAY_ELEMENT_TYPE_RULES PETR
WHERE PETR.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PETR.ELEMENT_SET_ID = PPA.ELEMENT_SET_ID
AND PETR.INCLUDE_OR_EXCLUDE = 'E')

Columns