APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 1280: , pay_run_results RR

1276: /* CURSOR csr_iea_weeks (p_balance_type_id in number) IS
1277: select nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0) weeks
1278: from pay_run_result_values TARGET
1279: , pay_balance_feeds_f FEED
1280: , pay_run_results RR
1281: , pay_assignment_actions ASSACT
1282: , pay_assignment_actions BAL_ASSACT
1283: , pay_payroll_actions PACT
1284: , pay_payroll_actions BACT

Line 1287: , pay_run_results PROCESS_RR

1283: , pay_payroll_actions PACT
1284: , pay_payroll_actions BACT
1285: , per_time_periods PPTP
1286: , per_time_periods BPTP
1287: , pay_run_results PROCESS_RR
1288: , pay_run_result_values PROCESS
1289: , pay_input_values_f PROCESS_IV
1290: , pay_action_contexts ACX_PROCESS_ID
1291: , ff_contexts CON_PROCESS_ID

Line 1325: , pay_run_results RR

1321: and RR.entry_type <>'B' -- Bug 3079945 start
1322: union all
1323: select nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0) weeks
1324: from pay_run_result_values TARGET
1325: , pay_run_results RR
1326: , pay_assignment_actions ASSACT
1327: , pay_balance_feeds_f FEED
1328: where ASSACT.assignment_action_id in (select min(assignment_action_id) from
1329: pay_assignment_actions where assignment_id = p_assignment_id)

Line 2229: pay_run_results pr,

2225: -- Bug 4315023 Removed Pay_element_types_f join for performance
2226: cursor cur_non_cum_tax is
2227: select result_value
2228: from pay_run_result_values prr,
2229: pay_run_results pr,
2230: pay_input_values_f piv,
2231: pay_assignment_actions pas,
2232: pay_payroll_actions ppa
2233: where pas.assignment_id in (select assignment_id