VIEW: APPS.PAY_PAYMENT_INFORMATION_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'