APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 1278: from pay_run_result_values TARGET

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

Line 1288: , pay_run_result_values PROCESS

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

Line 1324: from pay_run_result_values TARGET

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

Line 2228: from pay_run_result_values prr,

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