VIEW: APPS.PAY_PAYROLL_ACTIONS_V7

Source

View Text - Preformatted

SELECT PAC1.ROWID ROW_ID , PAC1.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID , PAC1.PAYROLL_ID , PAC1.PAYROLL_ACTION_ID , PAC1.ACTION_TYPE , PAC1.EFFECTIVE_DATE , PAC1.DATE_EARNED , HR_PAYROLLS.DISPLAY_PERIOD_NAME(PAC1.PAYROLL_ACTION_ID) PERIOD_NAME , LO1.MEANING , PRO.PAYROLL_NAME , DECODE(PAC1.ACTION_STATUS , 'P' , DECODE( REQUEST.PHASE_CODE,'C','E',PAC1.ACTION_STATUS) , PAC1.ACTION_STATUS) STATUS_CODE , PAC1.ACTION_STATUS , PAC1.ACTION_SEQUENCE , PAC1.DISPLAY_RUN_NUMBER , PAC1.CONSOLIDATION_SET_ID , PAC1.ASSIGNMENT_SET_ID , PAC1.ELEMENT_SET_ID , PAC1.REQUEST_ID , PAC1.COMMENTS FROM FND_CONCURRENT_REQUESTS REQUEST , HR_LOOKUPS LO1 , PER_TIME_PERIODS PTP , PAY_PAYROLLS_F PRO , PAY_PAYROLL_ACTIONS PAC1 WHERE PAC1.PAYROLL_ID = PTP.PAYROLL_ID AND PAC1.EFFECTIVE_DATE BETWEEN PTP.START_DATE AND PTP.END_DATE AND LO1.LOOKUP_TYPE = 'ACTION_TYPE' AND LO1.LOOKUP_CODE = PAC1.ACTION_TYPE AND PAC1.PAYROLL_ID = PRO.PAYROLL_ID AND PAC1.EFFECTIVE_DATE BETWEEN PRO.EFFECTIVE_START_DATE AND PRO.EFFECTIVE_END_DATE AND PAC1.ACTION_STATUS != 'U' AND PAC1.ACTION_TYPE != 'I' AND PAC1.REQUEST_ID = REQUEST.REQUEST_ID (+) UNION ALL SELECT PAC1.ROWID ROW_ID , PAC1.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID , PAC1.PAYROLL_ID , PAC1.PAYROLL_ACTION_ID , PAC1.ACTION_TYPE , PAC1.EFFECTIVE_DATE , PAC1.DATE_EARNED , NULL , LO1.MEANING , NULL , DECODE(PAC1.ACTION_STATUS , 'P' ,DECODE( REQUEST.PHASE_CODE,'C','E',PAC1.ACTION_STATUS) , PAC1.ACTION_STATUS) STATUS_CODE , PAC1.ACTION_STATUS , PAC1.ACTION_SEQUENCE , PAC1.DISPLAY_RUN_NUMBER , PAC1.CONSOLIDATION_SET_ID , PAC1.ASSIGNMENT_SET_ID , PAC1.ELEMENT_SET_ID , PAC1.REQUEST_ID , PAC1.COMMENTS FROM FND_CONCURRENT_REQUESTS REQUEST , HR_LOOKUPS LO1 , PAY_PAYROLL_ACTIONS PAC1 WHERE PAC1.PAYROLL_ID IS NULL AND LO1.LOOKUP_TYPE = 'ACTION_TYPE' AND LO1.LOOKUP_CODE = PAC1.ACTION_TYPE AND PAC1.ACTION_STATUS != ' U' AND PAC1.ACTION_TYPE != 'I' AND PAC1.REQUEST_ID = REQUEST.REQUEST_ID (+)

View Text - HTML Formatted

SELECT PAC1.ROWID ROW_ID
, PAC1.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, PAC1.PAYROLL_ID
, PAC1.PAYROLL_ACTION_ID
, PAC1.ACTION_TYPE
, PAC1.EFFECTIVE_DATE
, PAC1.DATE_EARNED
, HR_PAYROLLS.DISPLAY_PERIOD_NAME(PAC1.PAYROLL_ACTION_ID) PERIOD_NAME
, LO1.MEANING
, PRO.PAYROLL_NAME
, DECODE(PAC1.ACTION_STATUS
, 'P'
, DECODE( REQUEST.PHASE_CODE
, 'C'
, 'E'
, PAC1.ACTION_STATUS)
, PAC1.ACTION_STATUS) STATUS_CODE
, PAC1.ACTION_STATUS
, PAC1.ACTION_SEQUENCE
, PAC1.DISPLAY_RUN_NUMBER
, PAC1.CONSOLIDATION_SET_ID
, PAC1.ASSIGNMENT_SET_ID
, PAC1.ELEMENT_SET_ID
, PAC1.REQUEST_ID
, PAC1.COMMENTS
FROM FND_CONCURRENT_REQUESTS REQUEST
, HR_LOOKUPS LO1
, PER_TIME_PERIODS PTP
, PAY_PAYROLLS_F PRO
, PAY_PAYROLL_ACTIONS PAC1
WHERE PAC1.PAYROLL_ID = PTP.PAYROLL_ID
AND PAC1.EFFECTIVE_DATE BETWEEN PTP.START_DATE
AND PTP.END_DATE
AND LO1.LOOKUP_TYPE = 'ACTION_TYPE'
AND LO1.LOOKUP_CODE = PAC1.ACTION_TYPE
AND PAC1.PAYROLL_ID = PRO.PAYROLL_ID
AND PAC1.EFFECTIVE_DATE BETWEEN PRO.EFFECTIVE_START_DATE
AND PRO.EFFECTIVE_END_DATE
AND PAC1.ACTION_STATUS != 'U'
AND PAC1.ACTION_TYPE != 'I'
AND PAC1.REQUEST_ID = REQUEST.REQUEST_ID (+) UNION ALL SELECT PAC1.ROWID ROW_ID
, PAC1.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, PAC1.PAYROLL_ID
, PAC1.PAYROLL_ACTION_ID
, PAC1.ACTION_TYPE
, PAC1.EFFECTIVE_DATE
, PAC1.DATE_EARNED
, NULL
, LO1.MEANING
, NULL
, DECODE(PAC1.ACTION_STATUS
, 'P'
, DECODE( REQUEST.PHASE_CODE
, 'C'
, 'E'
, PAC1.ACTION_STATUS)
, PAC1.ACTION_STATUS) STATUS_CODE
, PAC1.ACTION_STATUS
, PAC1.ACTION_SEQUENCE
, PAC1.DISPLAY_RUN_NUMBER
, PAC1.CONSOLIDATION_SET_ID
, PAC1.ASSIGNMENT_SET_ID
, PAC1.ELEMENT_SET_ID
, PAC1.REQUEST_ID
, PAC1.COMMENTS
FROM FND_CONCURRENT_REQUESTS REQUEST
, HR_LOOKUPS LO1
, PAY_PAYROLL_ACTIONS PAC1
WHERE PAC1.PAYROLL_ID IS NULL
AND LO1.LOOKUP_TYPE = 'ACTION_TYPE'
AND LO1.LOOKUP_CODE = PAC1.ACTION_TYPE
AND PAC1.ACTION_STATUS != ' U'
AND PAC1.ACTION_TYPE != 'I'
AND PAC1.REQUEST_ID = REQUEST.REQUEST_ID (+)