SELECT pcs.CONSOLIDATION_SET_NAME ,pcs.CONSOLIDATION_SET_ID ,pcs.BUSINESS_GROUP_ID ,CASE WHEN (pcs.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, pcs.business_group_id)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE ,pcs.CONSOLIDATION_SET_NAME order_by FROM pay_consolidation_sets pcs UNION ALL SELECT null ,-1 ,-1 ,'Y' ,' ' order_by FROM dual
SELECT PCS.CONSOLIDATION_SET_NAME
, PCS.CONSOLIDATION_SET_ID
, PCS.BUSINESS_GROUP_ID
, CASE WHEN (PCS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PCS.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, PCS.CONSOLIDATION_SET_NAME ORDER_BY
FROM PAY_CONSOLIDATION_SETS PCS UNION ALL SELECT NULL
, -1
, -1
, 'Y'
, ' ' ORDER_BY
FROM DUAL
|
|
|