APPS.HZ_GEO_STRUCT_MAP_PUB dependencies on HZ_GEOGRAPHY_TYPES_B

Line 133: FROM hz_geography_types_b

129: x_ret_status := FND_API.G_RET_STS_SUCCESS;
130:
131: SELECT 'Exists'
132: INTO l_exists
133: FROM hz_geography_types_b
134: WHERE geography_type = UPPER(p_geo_type);
135:
136: EXCEPTION WHEN NO_DATA_FOUND THEN
137: x_ret_status := FND_API.G_RET_STS_ERROR;

Line 156: l_geo_type hz_geography_types_b.geography_type%TYPE;

152: START WITH parent_geography_type = p_parent_geo_type
153: AND country_code = p_country
154: CONNECT BY PRIOR geography_type = parent_geography_type
155: AND country_code = p_country;
156: l_geo_type hz_geography_types_b.geography_type%TYPE;
157: l_geo_element_col hz_geo_structure_levels.geography_element_column%TYPE;
158:
159: BEGIN
160: