eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_RETRO_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 151: INDEX(BACT_ASSACT PAY_ASSIGNMENT_ACTIONS_N1)

147: -- are excluded in the where clause(i.e. no retro-Geppen)
148:
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)

Line 155: INDEX(ASSACT PAY_ASSIGNMENT_ACTIONS_PK)

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)
158: INDEX(TARGET PAY_RUN_RESULT_VALUES_N50)
159: INDEX(FEED PAY_BALANCE_FEEDS_F_N2) */

Line 260: FROM pay_assignment_actions BACT_ASSACT, -- retro assact

256: -- retro assact
257: -- 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

Line 264: pay_assignment_actions ASSACT, -- target assact

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
267: pay_run_result_values TARGET, -- target result value
268: pay_balance_feeds_f FEED

Line 293: INDEX(BACT_ASSACT PAY_ASSIGNMENT_ACTIONS_N1)

289:
290: if l_min_effective_date is not NULL then
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)

Line 297: INDEX(ASSACT PAY_ASSIGNMENT_ACTIONS_PK)

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)
300: INDEX(TARGET PAY_RUN_RESULT_VALUES_N50)
301: INDEX(FEED PAY_BALANCE_FEEDS_F_N2) */

Line 304: FROM pay_assignment_actions BACT_ASSACT,

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,
305: pay_entry_process_details PEPD,
306: pay_payroll_actions BACT,
307: pay_run_results RR,
308: pay_assignment_actions ASSACT,

Line 308: pay_assignment_actions ASSACT,

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,
311: pay_run_result_values TARGET,
312: pay_balance_feeds_f FEED

Line 593: pay_assignment_actions paa

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
597: between p_effective_date_from and p_effective_date_to