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 653: select /*+ INDEX(PPR PAY_POPULATION_RANGES_N4)

649: ,cp_business_group_id in number
650: ,cp_start_date in date
651: ,cp_end_date in date
652: ) is
653: select /*+ INDEX(PPR PAY_POPULATION_RANGES_N4)
654: INDEX(PAF PER_ASSIGNMENTS_F_N12)
655: INDEX(PPA PAY_PAYROLL_ACTIONS_N50)
656: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51) */
657: paa.assignment_id,

Line 667: pay_population_ranges ppr

663: paa.payroll_action_id
664: from pay_payroll_actions ppa,
665: pay_assignment_actions paa,
666: per_assignments_f paf,
667: pay_population_ranges ppr
668: where ppr.payroll_action_id = cp_payroll_action_id
669: and ppr.chunk_number = cp_chunk_number
670: and paf.person_id = ppr.person_id
671: and ppa.effective_date between paf.effective_start_date