USP_MEMBERSHIPPROGRAMCONTRIBUTIONPROCESSSTATUS_DELETE

          CREATE procedure dbo.USP_MEMBERSHIPPROGRAMCONTRIBUTIONPROCESSSTATUS_DELETE
          (
              @ID uniqueidentifier,
              @CHANGEAGENTID uniqueidentifier
          )
          as begin
              set nocount on;

              if exists (select ID from dbo.BUSINESSPROCESSSTATUS    where ID = @ID and STATUSCODE = 1)
                          raiserror('Business process is still running',13,1);    

                        declare @CURRENTDATE datetime;
                        set @CURRENTDATE = getdate();

                        exec dbo.USP_BUSINESSPROCESSSTATUS_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID
                        return 0;

          end