APPS.HZ_GNR_PUB dependencies on HZ_GEO_STRUCTURE_LEVELS
Line 123: from hz_geo_structure_levels
119: l_addr_val_level_temp varchar2(30);
120:
121: CURSOR c_addr_val(p_country_code IN VARCHAR2) IS
122: select ADDR_VAL_LEVEL 123: from hz_geo_structure_levels 124: where PARENT_GEOGRAPHY_TYPE = 'COUNTRY'
125: and COUNTRY_CODE = p_country_code;
126: BEGIN
127: OPEN c_addr_val(p_country_code);