DBA Data[Home] [Help]

APPS.PAY_JP_UITE_ARCH_PKG dependencies on PAY_RUN_RESULTS

Line 1019: pay_run_results RR,

1015: SELECT 'Y'
1016: FROM pay_assignment_actions ASSACT,
1017: pay_payroll_actions PACT,
1018: pay_balance_feeds_f FEED,
1019: pay_run_results RR,
1020: pay_run_result_values TARGET
1021: WHERE ASSACT.assignment_action_id = p_assignment_action_id
1022: AND PACT.payroll_action_id = ASSACT.payroll_action_id
1023: AND RR.assignment_action_id = ASSACT.assignment_action_id

Line 1039: pay_run_results RR,

1035: SELECT ASSACT.assignment_action_id
1036: FROM pay_assignment_actions ASSACT,
1037: pay_payroll_actions PACT,
1038: pay_balance_feeds_f FEED,
1039: pay_run_results RR,
1040: pay_run_result_values TARGET
1041: WHERE PACT.payroll_action_id = ASSACT.payroll_action_id
1042: AND RR.assignment_action_id = ASSACT.assignment_action_id
1043: AND RR.status in ('P','PA')