APPS.HZ_GEO_UI_UTIL_PUB dependencies on HZ_GEOGRAPHIES

Line 21: , hz_geographies geo

17: is
18: select hr.child_id,
19: geo.geography_name
20: from hz_hierarchy_nodes hr
21: , hz_geographies geo
22: where hr.hierarchy_type = 'MASTER_REF'
23: and hr.parent_id = l_parent_id
24: and hr.parent_table_name = 'HZ_GEOGRAPHIES'
25: and hr.child_table_name = 'HZ_GEOGRAPHIES'

Line 24: and hr.parent_table_name = 'HZ_GEOGRAPHIES'

20: from hz_hierarchy_nodes hr
21: , hz_geographies geo
22: where hr.hierarchy_type = 'MASTER_REF'
23: and hr.parent_id = l_parent_id
24: and hr.parent_table_name = 'HZ_GEOGRAPHIES'
25: and hr.child_table_name = 'HZ_GEOGRAPHIES'
26: and hr.child_object_type = l_geo_type
27: and hr.status = 'A'
28: and hr.effective_end_date > sysdate

Line 25: and hr.child_table_name = 'HZ_GEOGRAPHIES'

21: , hz_geographies geo
22: where hr.hierarchy_type = 'MASTER_REF'
23: and hr.parent_id = l_parent_id
24: and hr.parent_table_name = 'HZ_GEOGRAPHIES'
25: and hr.child_table_name = 'HZ_GEOGRAPHIES'
26: and hr.child_object_type = l_geo_type
27: and hr.status = 'A'
28: and hr.effective_end_date > sysdate
29: and geo.geography_id = hr.child_id

Line 114: hz_geographies geo

110: is
111: select st.loc_tbl_name,
112: geo.geography_id
113: from Hz_geo_struct_map st,
114: hz_geographies geo
115: where map_id = l_map_id
116: AND st.country_code = geo.country_code
117: AND geo.geography_type = 'COUNTRY';
118:

Line 553: from hz_geographies

549:
550: cursor geo_cur(l_geography_id IN number)
551: is
552: select country_code
553: from hz_geographies
554: where geography_id = l_geography_id
555: and geography_type = 'COUNTRY';
556:
557: l_country_code varchar2(30);

Line 586: -- get country code from hz_geographies

582: l_value varchar(1);
583: BEGIN
584: l_value := 'N';
585: l_return := 'N';
586: -- get country code from hz_geographies
587: open geo_cur(p_geography_id);
588: fetch geo_cur into l_country_code;
589: close geo_cur;
590: if( l_country_code is not null)

Line 625: from hz_geographies g1,

621:
622: cursor get_ctry(l_geog_id varchar2)
623: is
624: select g2.geography_name
625: from hz_geographies g1,
626: hz_geographies g2
627: where g1.geography_id = l_geog_id
628: and g2.geography_id = g1.geography_element1_id
629: and g2.geography_type = 'COUNTRY';

Line 626: hz_geographies g2

622: cursor get_ctry(l_geog_id varchar2)
623: is
624: select g2.geography_name
625: from hz_geographies g1,
626: hz_geographies g2
627: where g1.geography_id = l_geog_id
628: and g2.geography_id = g1.geography_element1_id
629: and g2.geography_type = 'COUNTRY';
630: