View: PAY_PAYROLL_ACTIONS_V3

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_PAYROLL_ACTIONS_V3

View Text

SELECT PPA.PAYROLL_ACTION_ID
, PPA.DISPLAY_RUN_NUMBER || DECODE(HAS.ASSIGNMENT_SET_NAME
, NULL
, NULL
, '-') || HAS.ASSIGNMENT_SET_NAME || DECODE(PES.ELEMENT_SET_NAME
, NULL
, NULL
, '-') || PES.ELEMENT_SET_NAME
, HRL.MEANING
, PPA.BUSINESS_GROUP_ID + 0
FROM HR_ASSIGNMENT_SETS HAS
, PAY_ELEMENT_SETS PES
, PAY_PAYROLL_ACTIONS PPA
, HR_LOOKUPS HRL
WHERE HAS.ASSIGNMENT_SET_ID(+) = PPA.ASSIGNMENT_SET_ID
AND PES.ELEMENT_SET_ID(+) = PPA.ELEMENT_SET_ID
AND HRL.LOOKUP_TYPE = 'ACTION_TYPE'
AND HRL.LOOKUP_CODE = PPA.ACTION_TYPE
AND PPA.ACTION_TYPE = 'R' UNION SELECT PPA.PAYROLL_ACTION_ID
, PPA.DISPLAY_RUN_NUMBER || DECODE(PPE.FULL_NAME
, NULL
, NULL
, '-') || PPE.FULL_NAME
, HRL.MEANING
, PPA.BUSINESS_GROUP_ID + 0
FROM PER_PEOPLE_F PPE
, PER_ALL_ASSIGNMENTS_F PAS
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
, HR_LOOKUPS HRL
WHERE PPE.PERSON_ID = PAS.PERSON_ID
AND PAS.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PPA.EFFECTIVE_DATE BETWEEN PPE.EFFECTIVE_START_DATE
AND PPE.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN PAS.EFFECTIVE_START_DATE
AND PAS.EFFECTIVE_END_DATE
AND HRL.LOOKUP_TYPE = 'ACTION_TYPE'
AND HRL.LOOKUP_CODE = PPA.ACTION_TYPE
AND PPA.ACTION_TYPE = 'Q'

Columns