APPS.HZ_GEO_GET_PUB dependencies on HZ_GEO_STRUCTURE_LEVELS

Line 514: FROM hz_geo_structure_levels hgsl

510: conc_geo ConcGeoName;
511:
512: cursor g_structure is
513: SELECT geography_element_column
514: FROM hz_geo_structure_levels hgsl
515: START WITH PARENT_GEOGRAPHY_TYPE = 'COUNTRY'
516: and hgsl.geography_id = l_country_id
517: CONNECT BY PRIOR hgsl.GEOGRAPHY_TYPE = hgsl.PARENT_GEOGRAPHY_TYPE
518: and hgsl.geography_id = l_country_id