410: SELECT o.NAME
411: ,hoi3.org_information2 "ORG_NUMBER"
412: ,o.location_id
413: ,o.organization_id
414: FROM hr_all_organization_units o
415: ,hr_organization_information hoi1
416: ,hr_organization_information hoi2
417: ,hr_organization_information hoi3
418: WHERE o.business_group_id = g_business_group_id