SELECT O.ORGANIZATION_ID , O.NAME , CASE WHEN O.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID , O.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE , O.NAME ORDER_BY FROM HR_ALL_ORGANIZATION_UNITS O , HR_ORGANIZATION_INFORMATION O2 , HR_ORGANIZATION_INFORMATION O3 WHERE O3.ORG_INFORMATION_CONTEXT = 'CLASS' AND O3.ORG_INFORMATION1 = 'HR_LEGAL' AND O2.ORG_INFORMATION_CONTEXT(+) = 'EMPLOYER IDENTIFICATION' AND O.ORGANIZATION_ID = O2.ORGANIZATION_ID(+) AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID AND O3.ORG_INFORMATION2 = 'Y' UNION ALL SELECT -1 , NULL , 'Y' , ' ' ORDER_BY FROM DUAL