USP_ADDUPDATE_BATCHREVENUETRANSACTIONMAPPING

Create procedure dbo.USP_ADDUPDATE_BATCHREVENUETRANSACTIONMAPPING
(
@BATCHID uniqueidentifier,
@TRANSACTIONGUID uniqueidentifier,
@STATUS tinyint=0
)
as

begin
declare @CHANGEAGENTID UNIQUEIDENTIFIER;
    exec dbo.Usp_changeagent_getorcreatechangeagent @CHANGEAGENTID OUTPUT;

    declare @DATE datetime
    set @DATE = Getdate()

    declare @BATCHREVENUEID UNIQUEIDENTIFIER;

   Select @BATCHREVENUEID=ID from BATCHREVENUE 
   where SEQUENCE in ( Select max(SEQUENCE)From BATCHREVENUE Where BATCHID=@BATCHID group by BATCHID ) and BATCHID=@BATCHID

  if exists(Select top 1 * From BATCHREVENUETRANSACTIONMAPPING where TRANSACTIONGUID=@TRANSACTIONGUID)
   Begin
   Update BATCHREVENUETRANSACTIONMAPPING
   set 
    [STATUS]=@STATUS,
        [CHANGEDBYID] = @CHANGEAGENTID,
        [DATECHANGED] = @DATE
   Where TRANSACTIONGUID=@TRANSACTIONGUID  
   End
   Else
   Begin
    insert into BATCHREVENUETRANSACTIONMAPPING (
                [BATCHREVENUEID],
                [TRANSACTIONGUID],
                [STATUS],
                [ADDEDBYID],
                [CHANGEDBYID],
                [DATEADDED],
                [DATECHANGED]
            )
      values 
      (
                @BATCHREVENUEID,
                @TRANSACTIONGUID,
                @STATUS,
                @CHANGEAGENTID,
                @CHANGEAGENTID,
                @DATE,
                @DATE        
      )
      End

end