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.HR_LOCATION_RECORD dependencies on HR_LOCATIONS_ALL

Line 99: FROM hr_locations_all loc,

95: loc.ece_tp_location_code,
96: loc.object_version_number,
97: loc.legal_address_flag,
98: loc.timezone_code
99: FROM hr_locations_all loc,
100: hr_locations_all_tl lot
101: WHERE nvl(p_location_id, loc.LOCATION_ID) = loc.LOCATION_ID
102: AND loc.LOCATION_ID BETWEEN nvl(p_start_location_id, loc.LOCATION_ID)
103: AND nvl(p_end_location_id, loc.LOCATION_ID)

Line 100: hr_locations_all_tl lot

96: loc.object_version_number,
97: loc.legal_address_flag,
98: loc.timezone_code
99: FROM hr_locations_all loc,
100: hr_locations_all_tl lot
101: WHERE nvl(p_location_id, loc.LOCATION_ID) = loc.LOCATION_ID
102: AND loc.LOCATION_ID BETWEEN nvl(p_start_location_id, loc.LOCATION_ID)
103: AND nvl(p_end_location_id, loc.LOCATION_ID)
104: AND ((p_bg_id IS NULL) OR (p_bg_id IS NOT NULL AND p_bg_id = loc.BUSINESS_GROUP_ID))