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_MWR_REPORTING_PKG dependencies on HR_LOCATIONS_ALL

Line 623: hr_locations_all hl,

619:
620: CURSOR asg_with_action_loc_id IS
621: SELECT paaf.location_id
622: FROM per_all_assignments_f paaf,
623: hr_locations_all hl,
624: pay_us_states pus
625: WHERE paaf.effective_start_date <= p_effective_date
626: AND paaf.effective_end_date >= trunc(p_effective_date,'Q')
627: AND paaf.assignment_id = p_assignment_id

Line 648: hr_locations_all hl,

644:
645: CURSOR assignment_loc_id IS
646: SELECT paaf.location_id
647: FROM per_all_assignments_f paaf,
648: hr_locations_all hl,
649: pay_us_states pus
650: WHERE paaf.effective_start_date <= p_effective_date
651: AND paaf.effective_end_date >= trunc(p_effective_date,'Q')
652: AND paaf.assignment_id = p_assignment_id