SELECT ASET.ASSIGNMENT_SET_NAME , ASET.ASSIGNMENT_SET_ID , CASE WHEN ASET.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID , ASET.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE , ASET.ASSIGNMENT_SET_NAME ORDER_BY FROM HR_ASSIGNMENT_SETS ASET UNION ALL SELECT NULL , -1 , 'Y' , ' ' ORDER_BY FROM DUAL WITH READ ONLY