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 HZ_LOCATIONS

Line 98: IF p_location_table_name = 'HZ_LOCATIONS' THEN

94: END IF;
95:
96: -- To get country_code for the location
97: BEGIN
98: IF p_location_table_name = 'HZ_LOCATIONS' THEN
99: SELECT country
100: INTO l_country_code
101: FROM hz_locations
102: WHERE location_id = p_location_id;

Line 101: FROM hz_locations

97: BEGIN
98: IF p_location_table_name = 'HZ_LOCATIONS' 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

Line 219: ELSIF p_location_table_name = 'HZ_LOCATIONS' THEN

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:
221: SELECT postal_code
222: INTO l_postal_code
223: FROM hz_locations

Line 223: FROM hz_locations

219: ELSIF p_location_table_name = 'HZ_LOCATIONS' THEN
220:
221: SELECT postal_code
222: INTO l_postal_code
223: FROM hz_locations
224: WHERE location_id = p_location_id;
225:
226: END IF;
227: