APPS.HZ_GEO_GET_PUB dependencies on HZ_LOCATIONS

Line 120: IF p_location_table_name = 'HZ_LOCATIONS' THEN

116: END IF;
117:
118: -- To get country_code for the location
119: BEGIN
120: IF p_location_table_name = 'HZ_LOCATIONS' THEN
121: SELECT country
122: INTO l_country_code
123: FROM hz_locations
124: WHERE location_id = p_location_id;

Line 123: FROM hz_locations

119: BEGIN
120: IF p_location_table_name = 'HZ_LOCATIONS' 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

Line 283: ELSIF p_location_table_name = 'HZ_LOCATIONS' THEN

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:
285: SELECT postal_code
286: INTO l_postal_code
287: FROM hz_locations

Line 287: FROM hz_locations

283: ELSIF p_location_table_name = 'HZ_LOCATIONS' THEN
284:
285: SELECT postal_code
286: INTO l_postal_code
287: FROM hz_locations
288: WHERE location_id = p_location_id;
289:
290: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
291: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>' For Location '||p_location_id||' Postal Code is '||l_postal_code,