SELECT BAD.ATTRIBUTE_NAME , BAD.ALTERABLE , BAD.USER_ATTRIBUTE_NAME , BAD.BUSINESS_GROUP_ID , BAD.LEGISLATION_CODE , BAD.ATTRIBUTE_ID , BAD.LAST_UPDATE_DATE , BAD.LAST_UPDATED_BY , BAD.LAST_UPDATE_LOGIN , BAD.CREATED_BY , BAD.CREATION_DATE , CASE WHEN ((BAD.BUSINESS_GROUP_ID IS NULL AND BAD.LEGISLATION_CODE IS NULL) OR (BAD.BUSINESS_GROUP_ID IS NULL AND BAD.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE , BAD.LEGISLATION_CODE)) OR (BAD.BUSINESS_GROUP_ID= NVL(HR_BIS.GET_SEC_PROFILE_BG_ID , BAD.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PAY_BAL_ATTRIBUTE_DEFINITIONS BAD WITH READ ONLY