APPS.PAY_JP_RETRO_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 158: INDEX(TARGET PAY_RUN_RESULT_VALUES_N50)

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)
161: -- = retro salary to pay at target month(BACT) - retro salary paid at target month(PACT)
162: nvl(sum(decode(FEED.balance_type_id,

Line 267: pay_run_result_values TARGET, -- target result value

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
270: and PEPD.source_asg_action_id = BACT_ASSACT.assignment_action_id
271: and BACT.payroll_action_id = BACT_ASSACT.payroll_action_id

Line 300: INDEX(TARGET PAY_RUN_RESULT_VALUES_N50)

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)
303: INTO g_retro_diff_value
304: FROM pay_assignment_actions BACT_ASSACT,

Line 311: pay_run_result_values TARGET,

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
314: and PEPD.source_asg_action_id = BACT_ASSACT.assignment_action_id
315: and BACT.payroll_action_id = BACT_ASSACT.payroll_action_id