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_ELEMENT_ENTRIES_F

Line 157: INDEX(PEE PAY_ELEMENT_ENTRIES_F_PK)

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)
161: -- = retro salary to pay at target month(BACT) - retro salary paid at target month(PACT)

Line 242: -- 1) pay_element_entries_f.source_id is no index so that all query cause bad performance. reject.

238: l_min_effective_date,
239: g_retro_paid3,
240: g_retro_paid2,
241: g_retro_paid1
242: -- 1) pay_element_entries_f.source_id is no index so that all query cause bad performance. reject.
243: -- target assact(use assignment_id)
244: -- target pact(use effective_date)
245: -- target result(use status)
246: -- retro entries(use creator_type,entry_type)

Line 266: pay_element_entries_f PEE, -- retro element 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
270: and PEPD.source_asg_action_id = BACT_ASSACT.assignment_action_id

Line 299: INDEX(PEE PAY_ELEMENT_ENTRIES_F_PK)

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)
303: INTO g_retro_diff_value

Line 310: pay_element_entries_f PEE,

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