[Home] [Help]
View: PAY_PAYMENT_INFORMATION_V
View Text
SELECT DISTINCT PP_ASGACT.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, RUN_ASGACT.ASSIGNMENT_ID ASSIGNMENT_ID
, RUN_ASGACT.TAX_UNIT_ID TAX_UNIT_ID
, DECODE(NVL(PRT.RUN_METHOD
, 'N')
, 'S'
, RUN_ASGACT.ASSIGNMENT_ACTION_ID
, NULL ) SOURCE_ACTION_ID
, RUN_ASGACT.ACTION_STATUS
FROM PAY_ASSIGNMENT_ACTIONS PP_ASGACT
, PAY_PAYROLL_ACTIONS PP_PACT
, PAY_ACTION_INTERLOCKS PP_RUN
, PAY_ASSIGNMENT_ACTIONS RUN_ASGACT
, PAY_PAYROLL_ACTIONS RUN_PACT
, PAY_RUN_TYPES_F PRT
WHERE PP_PACT.ACTION_TYPE IN ( 'P'
, 'U' )
AND PP_ASGACT.PAYROLL_ACTION_ID = PP_PACT.PAYROLL_ACTION_ID
AND PP_RUN.LOCKING_ACTION_ID = PP_ASGACT.ASSIGNMENT_ACTION_ID
AND RUN_ASGACT.ASSIGNMENT_ACTION_ID = PP_RUN.LOCKED_ACTION_ID
AND RUN_PACT.PAYROLL_ACTION_ID = RUN_ASGACT.PAYROLL_ACTION_ID
AND RUN_PACT.ACTION_TYPE IN ( 'R'
, 'Q'
, 'V'
, 'B' )
AND RUN_ASGACT.RUN_TYPE_ID = PRT.RUN_TYPE_ID (+)
AND RUN_PACT.EFFECTIVE_DATE BETWEEN NVL(PRT.EFFECTIVE_START_DATE
, RUN_PACT.EFFECTIVE_DATE)
AND NVL(PRT.EFFECTIVE_END_DATE
, RUN_PACT.EFFECTIVE_DATE )
AND PRT.RUN_METHOD(+) <> 'C'
Columns
Name |
ASSIGNMENT_ACTION_ID |
ASSIGNMENT_ID |
TAX_UNIT_ID |
SOURCE_ACTION_ID |
ACTION_STATUS |