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 1361: --get geography_element_column,country_code from hz_geo_structure_levels for this geography_id

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

Line 1366: FROM HZ_GEO_STRUCTURE_LEVELS

1362: --dbms_output.put_line('before getting geo_element_column l_geography_id '||l_geography_id);
1363:
1364: SELECT distinct geography_element_column,country_code
1365: INTO l_geo_element_col,l_country_code
1366: FROM HZ_GEO_STRUCTURE_LEVELS
1367: WHERE geography_id = (SELECT geography_id FROM
1368: HZ_GEOGRAPHIES WHERE COUNTRY_CODE=(SELECT country_code from hz_geographies
1369: WHERE geography_id = l_geography_id)
1370: AND geography_type='COUNTRY')

Line 2377: FROM hz_geo_structure_levels st

2373: -- get child geo type for which geo range has to be created
2374: BEGIN
2375: SELECT st.geography_type
2376: INTO l_child_geo_type
2377: FROM hz_geo_structure_levels st
2378: ,hz_geography_types_b tp
2379: WHERE st.country_code = l_country_code
2380: AND st.parent_geography_type = l_parent_geo_type
2381: AND st.geography_type = tp.geography_type