VIEW: APPS.PAY_PAYROLL_ACTIONS_V3

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'