1858: , org_bg.ORG_INFORMATION9 legislation_code
1859: from hr_organization_information org_Legal_ent
1860: , hr_all_organization_units org_unit
1861: , hr_organization_information org_bg
1862: , hr_all_organization_units_tl org_unit_tl
1863: Where org_Legal_ent.ORG_INFORMATION_CONTEXT = 'CLASS'
1864: And org_Legal_ent.ORG_INFORMATION1 = 'HR_LEGAL'
1865: and org_Legal_ent.ORGANIZATION_ID = org_unit.ORGANIZATION_ID
1866: And org_bg.ORGANIZATION_ID = org_unit.BUSINESS_GROUP_ID