915: ,per_gen_hierarchy_versions pghv
916: ,per_gen_hierarchy_nodes pghn -- parent organization
917: ,per_gen_hierarchy_nodes pghn2 -- establishment organizations
918: ,hr_organization_information hoi
919: ,hr_organization_units hou
920: ,hr_locations loc
921: ,hr_location_extra_info lei
922: where pgh.hierarchy_id = Pay_Magtape_Generic.Get_Parameter_Value(
923: 'TRANSFER_HIERARCHY_ID') --parameter p_hierarchy_id