SELECT BA.BALANCE_ATTRIBUTE_ID , BA.ATTRIBUTE_ID , BA.DEFINED_BALANCE_ID , BA.BUSINESS_GROUP_ID , BA.LEGISLATION_CODE , BA.LAST_UPDATE_DATE , BA.LAST_UPDATED_BY , BA.LAST_UPDATE_LOGIN , BA.CREATED_BY , BA.CREATION_DATE , CASE WHEN ((BA.BUSINESS_GROUP_ID IS NULL AND BA.LEGISLATION_CODE IS NULL) OR (BA.BUSINESS_GROUP_ID IS NULL AND BA.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE , BA.LEGISLATION_CODE)) OR (BA.BUSINESS_GROUP_ID= NVL(HR_BIS.GET_SEC_PROFILE_BG_ID , BA.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PAY_BALANCE_ATTRIBUTES BA WITH READ ONLY