335: SELECT o.NAME
336: ,hoi3.org_information2 "ORG_NUMBER"
337: ,o.location_id
338: ,o.organization_id
339: FROM hr_all_organization_units o
340: ,hr_organization_information hoi1
341: ,hr_organization_information hoi2
342: ,hr_organization_information hoi3
343: WHERE o.business_group_id = g_business_group_id