USP_REVENUEBATCH_CUSTOMVALIDATE

CREATE procedure dbo.USP_REVENUEBATCH_CUSTOMVALIDATE (
  @BATCHROWID uniqueidentifier,
  @BATCHNUMBER nvarchar(255),
  @CHANGEAGENTID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @BATCHOWNERID uniqueidentifier
)
as
begin

    update dbo.BATCHREVENUEBATCHSYSTEMMESSAGES
      set MESSAGETEXT = 'Data in batch is different from data for this constituent. Click here to review.'
    where 
      BATCHREVENUEID = @BATCHROWID and 
      MESSAGETYPECODE = 1 and 
      SEVERITYCODE = 0 and 
      exists(select
                'x'
              from dbo.BATCHCONSTITUENTUPDATE where ID= @BATCHROWID and DOMANUALREVIEWFORAUTOMATCH = 1);
end