APPS.HZ_GEO_GET_PUB dependencies on HZ_GEOGRAPHIES

Line 35: AND subject_table_name = 'HZ_GEOGRAPHIES'

31: CURSOR c_get_zones(c_object_type IN VARCHAR2, c_geography_id IN NUMBER) IS
32: SELECT subject_id
33: FROM hz_relationships
34: WHERE subject_type = p_zone_type
35: AND subject_table_name = 'HZ_GEOGRAPHIES'
36: AND object_type = c_object_type
37: AND object_id = c_geography_id
38: AND object_table_name = 'HZ_GEOGRAPHIES'
39: AND relationship_type = 'TAX'

Line 38: AND object_table_name = 'HZ_GEOGRAPHIES'

34: WHERE subject_type = p_zone_type
35: AND subject_table_name = 'HZ_GEOGRAPHIES'
36: AND object_type = c_object_type
37: AND object_id = c_geography_id
38: AND object_table_name = 'HZ_GEOGRAPHIES'
39: AND relationship_type = 'TAX'
40: AND directional_flag = 'F'
41: AND relationship_code = 'PARENT_OF'
42: AND p_date BETWEEN start_date and end_date;

Line 201: FROM hz_geographies

197: -- if l_ref_geo_type is COUNTRY get geography_id from hz_geograpies
198: IF l_ref_geo_type = 'COUNTRY' THEN
199: SELECT geography_id
200: INTO l_geography_id
201: FROM hz_geographies
202: WHERE country_code = l_country_code
203: AND geography_type = l_ref_geo_type
204: -- Bug 5410283 (Added on 07-Aug-2006)
205: AND p_date BETWEEN start_date AND end_date;

Line 397: FROM hz_geographies

393: SELECT geography_id, geography_code, geography_name
394: INTO l_zone_tbl_final(l_tbl_count+1).zone_id,
395: l_zone_tbl_final(l_tbl_count+1).zone_code,
396: l_zone_tbl_final(l_tbl_count+1).zone_name
397: FROM hz_geographies
398: WHERE geography_id = l_zone_tbl(i).zone_id
399: -- Bug 5410283 (Added on 07-Aug-2006)
400: AND p_date BETWEEN start_date AND end_date;
401: l_zone_tbl_final(l_tbl_count+1).zone_type := p_zone_type;

Line 430: FROM hz_geographies

426: ELSE
427: BEGIN
428: SELECT geography_id, geography_code, geography_name
429: INTO l_zone_tbl_final(i).zone_id, l_zone_tbl_final(i).zone_code, l_zone_tbl_final(i).zone_name
430: FROM hz_geographies
431: WHERE geography_id = l_zone_tbl(i).zone_id
432: -- Bug 5410283 (Added on 07-Aug-2006)
433: AND p_date BETWEEN start_date AND end_date;
434:

Line 524: from hz_geographies

520:
521: Begin
522: Begin
523: select geography_element1_id, geography_type into l_country_id, l_geo_type
524: from hz_geographies
525: where geography_id = l_geo_id;
526: Exception
527: When no_data_found then
528: return hz_utility_v2pub.Get_LookupMeaning('AR_LOOKUPS', 'HZ_GEO_DISPLAY_ONLY', 'WORLD');

Line 542: 'select '||l_clause||' from hz_geographies where geography_id = :1' USING l_geo_id;

538: end loop;
539: close g_structure;
540:
541: OPEN conc_geo FOR
542: 'select '||l_clause||' from hz_geographies where geography_id = :1' USING l_geo_id;
543: fetch conc_geo into l_display_val;
544: close conc_geo;
545: return l_display_val;
546: end get_conc_name;