APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 1544: , pay_run_results RR

1540: /* CURSOR csr_iea_weeks (p_balance_type_id in number) IS
1541: select nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0) weeks
1542: from pay_run_result_values TARGET
1543: , pay_balance_feeds_f FEED
1544: , pay_run_results RR
1545: , pay_assignment_actions ASSACT
1546: , pay_assignment_actions BAL_ASSACT
1547: , pay_payroll_actions PACT
1548: , pay_payroll_actions BACT

Line 1551: , pay_run_results PROCESS_RR

1547: , pay_payroll_actions PACT
1548: , pay_payroll_actions BACT
1549: , per_time_periods PPTP
1550: , per_time_periods BPTP
1551: , pay_run_results PROCESS_RR
1552: , pay_run_result_values PROCESS
1553: , pay_input_values_f PROCESS_IV
1554: , pay_action_contexts ACX_PROCESS_ID
1555: , ff_contexts CON_PROCESS_ID

Line 1589: , pay_run_results RR

1585: and RR.entry_type <>'B' -- Bug 3079945 start
1586: union all
1587: select nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0) weeks
1588: from pay_run_result_values TARGET
1589: , pay_run_results RR
1590: , pay_assignment_actions ASSACT
1591: , pay_balance_feeds_f FEED
1592: where ASSACT.assignment_action_id in (select min(assignment_action_id) from
1593: pay_assignment_actions where assignment_id = p_assignment_id)

Line 2896: pay_run_results pr,

2892: -- Bug 4315023 Removed Pay_element_types_f join for performance
2893: cursor cur_non_cum_tax is
2894: select result_value
2895: from pay_run_result_values prr,
2896: pay_run_results pr,
2897: pay_input_values_f piv,
2898: pay_assignment_actions pas,
2899: pay_payroll_actions ppa
2900: where pas.assignment_id in (select assignment_id