Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAY_PAYMENT_ACTIONS_V |
SELECT PAA_PP.ASSIGNMENT_ACTION_ID
, PAA_PP.ASSIGNMENT_ID
, PAA_PP.PAYROLL_ACTION_ID
, PAA_PP.ACTION_STATUS
, PAA_PP.CHUNK_NUMBER
, PAA_PP.ACTION_SEQUENCE
, PAA_PP.PRE_PAYMENT_ID
, PAA_PP.SERIAL_NUMBER
, PAA_PP.OBJECT_VERSION_NUMBER
, PAA_PP.TAX_UNIT_ID
, PAA_PP.SOURCE_ACTION_ID
, PAA_PP.RUN_TYPE_ID
, PAA_RUN.ASSIGNMENT_ACTION_ID
, PAA_RUN.ASSIGNMENT_ID
, PAA_RUN.PAYROLL_ACTION_ID
, PAA_RUN.ACTION_STATUS
, PAA_RUN.CHUNK_NUMBER
, PAA_RUN.ACTION_SEQUENCE
, PAA_RUN.PRE_PAYMENT_ID
, PAA_RUN.SERIAL_NUMBER
, PAA_RUN.OBJECT_VERSION_NUMBER
, PAA_RUN.TAX_UNIT_ID
, PAA_RUN.SOURCE_ACTION_ID
, PAA_RUN.RUN_TYPE_ID
, PPA_RUN.RUN_TYPE_ID
, PRT.RUN_METHOD
, PPA_RUN.EFFECTIVE_DATE
, PPA_RUN.DATE_EARNED
, PPA_RUN.PAYROLL_ID
, PPP.PRE_PAYMENT_ID
, PPP.PERSONAL_PAYMENT_METHOD_ID
, PPP.ORG_PAYMENT_METHOD_ID
, PPP.VALUE
, PPP.BASE_CURRENCY_VALUE
, PPP.SOURCE_ACTION_ID
, NVL(PPP.SOURCE_ACTION_ID
, NVL(PAA_RUN.SOURCE_ACTION_ID
, PAA_RUN.ASSIGNMENT_ACTION_ID))
, DECODE (NVL (PAA_RUN.SOURCE_ACTION_ID
, -999)
, -999
, DECODE(NVL(PPA_RUN.RUN_TYPE_ID
, -999)
, -999
, 'N'
, 'Y')
, 'N')
FROM PAY_PRE_PAYMENTS PPP
, PAY_ASSIGNMENT_ACTIONS PAA_PP
, PAY_ACTION_INTERLOCKS PAI
, PAY_ASSIGNMENT_ACTIONS PAA_RUN
, PAY_PAYROLL_ACTIONS PPA_RUN
, PAY_RUN_TYPES_F PRT
WHERE PPP.ASSIGNMENT_ACTION_ID = PAA_PP.ASSIGNMENT_ACTION_ID
AND PAI.LOCKING_ACTION_ID = PAA_PP.ASSIGNMENT_ACTION_ID
AND PAI.LOCKED_ACTION_ID = PAA_RUN.ASSIGNMENT_ACTION_ID
AND PAA_RUN.RUN_TYPE_ID = PRT.RUN_TYPE_ID (+)
AND PAA_RUN.PAYROLL_ACTION_ID = PPA_RUN.PAYROLL_ACTION_ID
AND PPA_RUN.EFFECTIVE_DATE BETWEEN NVL(PRT.EFFECTIVE_START_DATE
, PPA_RUN.EFFECTIVE_DATE)
AND NVL(PRT.EFFECTIVE_END_DATE
, PPA_RUN.EFFECTIVE_DATE)
AND PAA_RUN.ASSIGNMENT_ACTION_ID = DECODE (NVL(PPP.SOURCE_ACTION_ID
, -999)
, -999
, DECODE (NVL(PRT.RUN_METHOD
, 'N')
, 'S'
, -999
, PAA_RUN.ASSIGNMENT_ACTION_ID)
, PPP.SOURCE_ACTION_ID)