1659: select
1660: pghn1.hierarchy_node_id
1661: from
1662: per_gen_hierarchy_nodes pghn1
1663: ,hr_location_extra_info hlei1
1664: ,hr_location_extra_info hlei2
1665: ,hr_locations_all eloc
1666: where
1667: (pghn1.hierarchy_version_id = P_HIERARCHY_VERSION_ID
1660: pghn1.hierarchy_node_id
1661: from
1662: per_gen_hierarchy_nodes pghn1
1663: ,hr_location_extra_info hlei1
1664: ,hr_location_extra_info hlei2
1665: ,hr_locations_all eloc
1666: where
1667: (pghn1.hierarchy_version_id = P_HIERARCHY_VERSION_ID
1668: and pghn1.node_type = 'EST'