APPS.ZX_HR_LOCATIONS_GNR_HOOK dependencies on HZ_HIERARCHY_NODES
Line 99: FROM hz_hierarchy_nodes nodes, hz_geographies geo
95:
96: BEGIN
97: SELECT child_id
98: INTO l_geography_id_tbl(i) 99: FROM hz_hierarchy_nodes nodes, hz_geographies geo 100: WHERE parent_id = l_geography_id_tbl(i-1)
101: AND parent_object_type = l_geography_type(i-1)
102: AND child_object_type = l_geography_type(i)
103: AND nodes.child_id = geo.geography_id