APPS.PAY_JP_RETRO_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 153: INDEX(BACT PAY_PAYROLL_ACTIONS_PK)

149:
150: SELECT /*+ ORDERED
151: INDEX(BACT_ASSACT PAY_ASSIGNMENT_ACTIONS_N1)
152: INDEX(PEPD PAY_ENTRY_PROCESS_DETAILS_FK2)
153: INDEX(BACT PAY_PAYROLL_ACTIONS_PK)
154: INDEX(RR PAY_RUN_RESULTS_N51)
155: INDEX(ASSACT PAY_ASSIGNMENT_ACTIONS_PK)
156: INDEX(PACT PAY_PAYROLL_ACTIONS_PK)
157: INDEX(PEE PAY_ELEMENT_ENTRIES_F_PK)

Line 156: INDEX(PACT PAY_PAYROLL_ACTIONS_PK)

152: INDEX(PEPD PAY_ENTRY_PROCESS_DETAILS_FK2)
153: INDEX(BACT PAY_PAYROLL_ACTIONS_PK)
154: INDEX(RR PAY_RUN_RESULTS_N51)
155: INDEX(ASSACT PAY_ASSIGNMENT_ACTIONS_PK)
156: INDEX(PACT PAY_PAYROLL_ACTIONS_PK)
157: INDEX(PEE PAY_ELEMENT_ENTRIES_F_PK)
158: INDEX(TARGET PAY_RUN_RESULT_VALUES_N50)
159: INDEX(FEED PAY_BALANCE_FEEDS_F_N2) */
160: -- retro salary diff(adjusted amount to pay actually)

Line 262: pay_payroll_actions BACT, -- retro pact

258: -- target result value
259: -- target feed(use balance_type_id)
260: FROM pay_assignment_actions BACT_ASSACT, -- retro assact
261: pay_entry_process_details PEPD, -- retro entries
262: pay_payroll_actions BACT, -- retro pact
263: pay_run_results RR, -- target result
264: pay_assignment_actions ASSACT, -- target assact
265: pay_payroll_actions PACT, -- target pact
266: pay_element_entries_f PEE, -- retro element entries

Line 265: pay_payroll_actions PACT, -- target pact

261: pay_entry_process_details PEPD, -- retro entries
262: pay_payroll_actions BACT, -- retro pact
263: pay_run_results RR, -- target result
264: pay_assignment_actions ASSACT, -- target assact
265: pay_payroll_actions PACT, -- target pact
266: pay_element_entries_f PEE, -- retro element entries
267: pay_run_result_values TARGET, -- target result value
268: pay_balance_feeds_f FEED
269: WHERE BACT_ASSACT.assignment_id = p_assignment_id

Line 295: INDEX(BACT PAY_PAYROLL_ACTIONS_PK)

291:
292: SELECT /*+ ORDERED
293: INDEX(BACT_ASSACT PAY_ASSIGNMENT_ACTIONS_N1)
294: INDEX(PEPD PAY_ENTRY_PROCESS_DETAILS_FK2)
295: INDEX(BACT PAY_PAYROLL_ACTIONS_PK)
296: INDEX(RR PAY_RUN_RESULTS_N51)
297: INDEX(ASSACT PAY_ASSIGNMENT_ACTIONS_PK)
298: INDEX(PACT PAY_PAYROLL_ACTIONS_PK)
299: INDEX(PEE PAY_ELEMENT_ENTRIES_F_PK)

Line 298: INDEX(PACT PAY_PAYROLL_ACTIONS_PK)

294: INDEX(PEPD PAY_ENTRY_PROCESS_DETAILS_FK2)
295: INDEX(BACT PAY_PAYROLL_ACTIONS_PK)
296: INDEX(RR PAY_RUN_RESULTS_N51)
297: INDEX(ASSACT PAY_ASSIGNMENT_ACTIONS_PK)
298: INDEX(PACT PAY_PAYROLL_ACTIONS_PK)
299: INDEX(PEE PAY_ELEMENT_ENTRIES_F_PK)
300: INDEX(TARGET PAY_RUN_RESULT_VALUES_N50)
301: INDEX(FEED PAY_BALANCE_FEEDS_F_N2) */
302: nvl(sum(fnd_number.canonical_to_number(target.result_value)),0)

Line 306: pay_payroll_actions BACT,

302: nvl(sum(fnd_number.canonical_to_number(target.result_value)),0)
303: INTO g_retro_diff_value
304: FROM pay_assignment_actions BACT_ASSACT,
305: pay_entry_process_details PEPD,
306: pay_payroll_actions BACT,
307: pay_run_results RR,
308: pay_assignment_actions ASSACT,
309: pay_payroll_actions PACT,
310: pay_element_entries_f PEE,

Line 309: pay_payroll_actions PACT,

305: pay_entry_process_details PEPD,
306: pay_payroll_actions BACT,
307: pay_run_results RR,
308: pay_assignment_actions ASSACT,
309: pay_payroll_actions PACT,
310: pay_element_entries_f PEE,
311: pay_run_result_values TARGET,
312: pay_balance_feeds_f FEED
313: WHERE BACT_ASSACT.assignment_id = p_assignment_id

Line 592: pay_payroll_actions ppa,

588: l_last_assact NUMBER;
589: CURSOR csr_last_assact IS
590: select paa.assignment_action_id
591: from pay_action_classifications pac,
592: pay_payroll_actions ppa,
593: pay_assignment_actions paa
594: where paa.assignment_id=p_assignment_id
595: and ppa.payroll_action_id=paa.payroll_action_id
596: and ppa.effective_date