APPS.HZ_GEOGRAPHY_PUB dependencies on HZ_GEO_STRUCTURE_LEVELS

Line 109: hz_geo_structure_levels geo_struct

105: )
106: GROUP BY parent_object_type, level_number
107: ORDER BY level_number desc
108: ) geo_temp,
109: hz_geo_structure_levels geo_struct
110: WHERE geo_temp.parent_object_type = DECODE(geo_temp.parent_object_type,
111: 'COUNTRY',geo_struct.parent_geography_type,
112: geo_struct.geography_type)
113: AND country_code = l_country_code

Line 191: FROM HZ_GEO_STRUCTURE_LEVELS

187:
188: IF l_get_all_parents.parent_object_type <> 'COUNTRY' THEN
189: -- get geography_element_column for this geography_type
190: SELECT geography_element_column INTO l_geo_element_col
191: FROM HZ_GEO_STRUCTURE_LEVELS
192: WHERE geography_type=l_get_all_parents.parent_object_type
193: AND country_code = l_country_code
194: AND rownum <2 ;
195:

Line 347: FROM hz_geo_structure_levels

343:
344: BEGIN
345: --get geography_element_column from structures
346: SELECT distinct geography_element_column INTO l_geo_element_col
347: FROM hz_geo_structure_levels
348: WHERE geography_type = l_parent_object_type
349: AND geography_id = (select geography_id from hz_geographies where country_code=
350: (select country_code from hz_geographies where geography_id=p_geography_id)
351: and geography_type = 'COUNTRY'); -- Bug4680789

Line 1356: --get geography_element_column,country_code from hz_geo_structure_levels for this geography_id

1352: ----dbms_output.put_line('after identifier insert');
1353:
1354: IF (l_geography_type <> 'COUNTRY' AND l_geography_use = 'MASTER_REF') THEN
1355: BEGIN
1356: --get geography_element_column,country_code from hz_geo_structure_levels for this geography_id
1357: --dbms_output.put_line('before getting geo_element_column l_geography_id '||l_geography_id);
1358:
1359: SELECT distinct geography_element_column,country_code
1360: INTO l_geo_element_col,l_country_code

Line 1361: FROM HZ_GEO_STRUCTURE_LEVELS

1357: --dbms_output.put_line('before getting geo_element_column l_geography_id '||l_geography_id);
1358:
1359: SELECT distinct geography_element_column,country_code
1360: INTO l_geo_element_col,l_country_code
1361: FROM HZ_GEO_STRUCTURE_LEVELS
1362: WHERE geography_id = (SELECT geography_id FROM
1363: HZ_GEOGRAPHIES WHERE COUNTRY_CODE=(SELECT country_code from hz_geographies
1364: WHERE geography_id = l_geography_id)
1365: AND geography_type='COUNTRY')

Line 2364: FROM hz_geo_structure_levels st

2360: -- get child geo type for which geo range has to be created
2361: BEGIN
2362: SELECT st.geography_type
2363: INTO l_child_geo_type
2364: FROM hz_geo_structure_levels st
2365: ,hz_geography_types_b tp
2366: WHERE st.country_code = l_country_code
2367: AND st.parent_geography_type = l_parent_geo_type
2368: AND st.geography_type = tp.geography_type