339: IS
340: SELECT
341: hoi.organization_id
342: FROM
343: hr_organization_information hoi,
344: hr_organization_information hoi2
345: WHERE
346: hoi.org_information_context = 'CLASS'
347: AND hoi.org_information1 = 'HR_BG'
340: SELECT
341: hoi.organization_id
342: FROM
343: hr_organization_information hoi,
344: hr_organization_information hoi2
345: WHERE
346: hoi.org_information_context = 'CLASS'
347: AND hoi.org_information1 = 'HR_BG'
348: AND hoi.organization_id = hoi2.organization_id