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.HZ_GEO_GET_PUB dependencies on HR_LOCATIONS

Line 125: ELSIF p_location_table_name = 'HR_LOCATIONS_ALL' THEN

121: SELECT country
122: INTO l_country_code
123: FROM hz_locations
124: WHERE location_id = p_location_id;
125: ELSIF p_location_table_name = 'HR_LOCATIONS_ALL' THEN
126: SELECT country
127: INTO l_country_code
128: FROM hr_locations
129: WHERE location_id = p_location_id;

Line 128: FROM hr_locations

124: WHERE location_id = p_location_id;
125: ELSIF p_location_table_name = 'HR_LOCATIONS_ALL' THEN
126: SELECT country
127: INTO l_country_code
128: FROM hr_locations
129: WHERE location_id = p_location_id;
130: END IF;
131:
132: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 276: IF p_location_table_name = 'HR_LOCATIONS_ALL' THEN

272: IF l_count > 0 THEN
273:
274: -- Removed PO_VENDOR_SITES_ALL from the below if condition. Bug # 4584465
275:
276: IF p_location_table_name = 'HR_LOCATIONS_ALL' THEN
277:
278: SELECT postal_code
279: INTO l_postal_code
280: FROM hr_locations_all

Line 280: FROM hr_locations_all

276: IF p_location_table_name = 'HR_LOCATIONS_ALL' THEN
277:
278: SELECT postal_code
279: INTO l_postal_code
280: FROM hr_locations_all
281: WHERE location_id = p_location_id;
282:
283: ELSIF p_location_table_name = 'HZ_LOCATIONS' THEN
284: