120: ,per_gen_hierarchy_versions pghv
121: ,per_gen_hierarchy_nodes pghn -- parent organization
122: ,per_gen_hierarchy_nodes pghn2 -- establishment organizations
123: ,hr_organization_information hoi
124: ,hr_organization_units hou
125: ,hr_locations loc
126: ,hr_location_extra_info lei
127: where pgh.hierarchy_id = Pay_Magtape_Generic.Get_Parameter_Value(
128: 'TRANSFER_HIERARCHY_ID') --parameter p_hierarchy_id