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 614: -- get country code from hz_geographies

610: l_value varchar(1);
611: BEGIN
612: l_value := 'N';
613: l_return := 'N';
614: -- get country code from hz_geographies
615: open geo_cur(p_geography_id);
616: fetch geo_cur into l_country_code;
617: close geo_cur;
618: if( l_country_code is not null)

Line 653: from hz_geographies g1,

649:
650: cursor get_ctry(l_geog_id varchar2)
651: is
652: select g2.geography_name
653: from hz_geographies g1,
654: hz_geographies g2
655: where g1.geography_id = l_geog_id
656: and g2.geography_id = g1.geography_element1_id
657: and g2.geography_type = 'COUNTRY';

Line 654: hz_geographies g2

650: cursor get_ctry(l_geog_id varchar2)
651: is
652: select g2.geography_name
653: from hz_geographies g1,
654: hz_geographies g2
655: where g1.geography_id = l_geog_id
656: and g2.geography_id = g1.geography_element1_id
657: and g2.geography_type = 'COUNTRY';
658: