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
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
|
|
|