APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 1542: from pay_run_result_values TARGET

1538: -- First part of the select retrives summed up values for Payroll runs,
1539: -- Second part of the select retrives summed up values for Uploaded Balance
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

Line 1552: , pay_run_result_values PROCESS

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
1556: where BAL_ASSACT.assignment_action_id = p_source_id

Line 1588: from pay_run_result_values TARGET

1584: and PPTP.regular_payment_date >= trunc(BPTP.regular_payment_date,'Y')
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

Line 2895: from pay_run_result_values prr,

2891: where psb.assignment_id = p_assignment_id; */
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