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

Line 338: ,hr_locations hl

334: pus.state_abbrev
335: FROM ff_archive_items fai
336: ,ff_user_entities ue
337: ,pay_us_states pus
338: ,hr_locations hl
339: where hl.location_id = fai.value
340: and fai.user_entity_id = ue.user_entity_id
341: and ue.user_entity_name =
342: decode(p_mon_of_qtr,4,'A_SQWL_LOC_QTR_END','A_SQWL_LOC_MON_' || to_char(p_mon_of_qtr))

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