Product: | PAY - Payroll |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PAY_PAYROLL_ACTIONS_V4 |
SELECT PAC.PAYROLL_ACTION_ID
, PAC.EFFECTIVE_DATE
, PAC.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, PAC.PAYROLL_ID
, HR_PAYROLLS.DISPLAY_PERIOD_NAME(PAC.PAYROLL_ACTION_ID) PAID_PERIOD
, PAC.LEGISLATIVE_PARAMETERS
, PAC.DATE_EARNED
, PAC.ACTION_POPULATION_STATUS
, PAC.DISPLAY_RUN_NUMBER DB_DISPLAY_RUN_NUMBER
, PAC.CONSOLIDATION_SET_ID
, PCS.CONSOLIDATION_SET_NAME CONSOLIDATION_NAME
, PAC.PAY_ADVICE_DATE
, PAC.PAY_ADVICE_MESSAGE
, PAC.COMMENTS
, PAC.OBJECT_VERSION_NUMBER P_OBJECT_VERSION_NUMBER
, AAC.OBJECT_VERSION_NUMBER A_OBJECT_VERSION_NUMBER
, AAC.ASSIGNMENT_ACTION_ID
, AAC.ASSIGNMENT_ID
, AAC.ACTION_STATUS DB_ACTION_STATUS
, PAC.ACTION_SEQUENCE
, PAC.LAST_UPDATE_DATE
, PAC.LAST_UPDATED_BY
, PAC.LAST_UPDATE_LOGIN
, PAC.CREATED_BY
, PAC.CREATION_DATE
, PAC.RUN_TYPE_ID
FROM PAY_PAYROLL_ACTIONS PAC
, PAY_ASSIGNMENT_ACTIONS AAC
, PAY_CONSOLIDATION_SETS PCS
WHERE /* CONSOLIDATION SET */ PCS.CONSOLIDATION_SET_ID(+) = PAC.CONSOLIDATION_SET_ID /* RESTRICTIONS
AND JOINS TO PAY_ASSIGNMENT_ACTIONS */
AND PAC.PAYROLL_ACTION_ID = AAC.PAYROLL_ACTION_ID
AND AAC.SOURCE_ACTION_ID IS NULL
AND PAC.ACTION_TYPE = 'Q'