VIEW: APPS.PAY_PAYROLL_ACTIONS_V4

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'