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 103: ELSIF p_location_table_name = 'HR_LOCATIONS_ALL' THEN

99: SELECT country
100: INTO l_country_code
101: FROM hz_locations
102: WHERE location_id = p_location_id;
103: ELSIF p_location_table_name = 'HR_LOCATIONS_ALL' THEN
104: SELECT country
105: INTO l_country_code
106: FROM hr_locations
107: WHERE location_id = p_location_id;

Line 106: FROM hr_locations

102: WHERE location_id = p_location_id;
103: ELSIF p_location_table_name = 'HR_LOCATIONS_ALL' THEN
104: SELECT country
105: INTO l_country_code
106: FROM hr_locations
107: WHERE location_id = p_location_id;
108: END IF;
109: EXCEPTION WHEN others THEN
110: l_country_code := NULL;

Line 212: IF p_location_table_name = 'HR_LOCATIONS_ALL' THEN

208: IF l_count > 0 THEN
209:
210: -- Removed PO_VENDOR_SITES_ALL from the below if condition. Bug # 4584465
211:
212: IF p_location_table_name = 'HR_LOCATIONS_ALL' THEN
213:
214: SELECT postal_code
215: INTO l_postal_code
216: FROM hr_locations_all

Line 216: FROM hr_locations_all

212: IF p_location_table_name = 'HR_LOCATIONS_ALL' THEN
213:
214: SELECT postal_code
215: INTO l_postal_code
216: FROM hr_locations_all
217: WHERE location_id = p_location_id;
218:
219: ELSIF p_location_table_name = 'HZ_LOCATIONS' THEN
220: