APPS.HZ_GEO_UI_UTIL_PUB dependencies on HZ_HIERARCHY_NODES

Line 20: from hz_hierarchy_nodes hr

16: , l_geo_code in varchar2)
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'