APPS.EDW_GEOGRAPHY_PKG dependencies on HZ_LOCATIONS

Line 52: from hz_locations

48: END IF;
49:
50: select city, postal_code, decode(state, null, province, state), country
51: into l_city, l_postal_code, l_state, l_country
52: from hz_locations
53: where location_id = p_location_id;
54:
55: l_postcode_city := l_city || '-' || l_postal_code || '-' ||
56: l_state || '-' || l_country;