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_US_ACTION_ARCH dependencies on PAY_POPULATION_RANGES

Line 752: select /*+ INDEX(PPR PAY_POPULATION_RANGES_N4)

748: ,cp_business_group_id in number
749: ,cp_start_date in date
750: ,cp_end_date in date
751: ) is
752: select /*+ INDEX(PPR PAY_POPULATION_RANGES_N4)
753: INDEX(PAF PER_ASSIGNMENTS_F_N12)
754: INDEX(PPA PAY_PAYROLL_ACTIONS_N50)
755: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51) */
756: paa.assignment_id,

Line 766: pay_population_ranges ppr

762: paa.payroll_action_id
763: from pay_payroll_actions ppa,
764: pay_assignment_actions paa,
765: per_assignments_f paf,
766: pay_population_ranges ppr
767: where ppr.payroll_action_id = cp_payroll_action_id
768: and ppr.chunk_number = cp_chunk_number
769: and paf.person_id = ppr.person_id
770: and ppa.effective_date between paf.effective_start_date