APPS.HZ_GEO_GET_PUB dependencies on HZ_GEO_STRUCTURE_LEVELS

Line 361: FROM hz_geo_structure_levels hgsl

357: conc_geo ConcGeoName;
358:
359: cursor g_structure is
360: SELECT geography_element_column
361: FROM hz_geo_structure_levels hgsl
362: START WITH PARENT_GEOGRAPHY_TYPE = 'COUNTRY'
363: and hgsl.geography_id = l_country_id
364: CONNECT BY PRIOR hgsl.GEOGRAPHY_TYPE = hgsl.PARENT_GEOGRAPHY_TYPE
365: and hgsl.geography_id = l_country_id