SELECT T.RUN_TYPE_NAME , B.RUN_TYPE_ID , CASE WHEN ((B.BUSINESS_GROUP_ID IS NULL AND B.LEGISLATION_CODE IS NULL) OR (B.BUSINESS_GROUP_ID IS NULL AND B.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE , B.LEGISLATION_CODE)) OR (B.BUSINESS_GROUP_ID= NVL(HR_BIS.GET_SEC_PROFILE_BG_ID , B.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE , T.RUN_TYPE_NAME ORDER_BY FROM PAY_RUN_TYPES_F_TL T , PAY_RUN_TYPES_F B WHERE B.RUN_TYPE_ID = T.RUN_TYPE_ID AND T.LANGUAGE = USERENV('LANG') UNION ALL SELECT NULL , -1 , 'Y' , ' ' ORDER_BY FROM DUAL WITH READ ONLY