139: hr_location_extra_info hlei1
140: ,hr_location_extra_info hlei2
141: ,per_gen_hierarchy_nodes pghn
142: ,per_gen_hierarchy_nodes pgn
143: ,hr_locations_all eloc
144: ,hr_organization_units hou
145: ,hr_organization_information hoi1
146: ,hr_organization_information hoi2
147: ,hr_organization_information hoi3
144: ,hr_organization_units hou
145: ,hr_organization_information hoi1
146: ,hr_organization_information hoi2
147: ,hr_organization_information hoi3
148: ,hr_locations_all cloc
149: where pgn.hierarchy_version_id = pghn.hierarchy_version_id
150: and pgn.node_type = 'PAR'
151: and pgn.entity_id = hou.organization_id
152: and hoi1.org_information_context = 'VETS_Spec'