89: from
90: hr_location_extra_info hlei1
91: ,hr_location_extra_info hlei2
92: ,per_gen_hierarchy_nodes pghn
93: ,hr_locations_all eloc
94: where
95: (hlei1.information_type = 'VETS-100 Specific Information'
96: and hlei1.lei_information_category= 'VETS-100 Specific Information')
97: and (hlei2.information_type = 'Establishment Information'