View: PAY_KR_SEP_RESULT_RR_V

Product:	PAY - Payroll
Description:	This view returns Result of Separation Pay Process based on assignment_action_id.
Implementation/DBA Data:	APPS.PAY_KR_SEP_RESULT_RR_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
, PRR.RUN_RESULT_ID RUN_RESULT_ID
, PRR.ENTRY_TYPE ENTRY_TYPE
, PRR.SOURCE_ID SOURCE_ID
, PRR.SOURCE_TYPE SOURCE_TYPE
, PET.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, PET.ELEMENT_NAME ELEMENT_NAME
, PETL.ELEMENT_NAME UELEMENT_NAME
, PET.PROCESSING_PRIORITY PROCESSING_PRIORITY
, 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_RUN_RESULTS PRR
, 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 PRR.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PET.ELEMENT_TYPE_ID = PRR.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')

Columns