USP_APPUSERCLAIMSLINK_DELETE

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

        if @CHANGEAGENTID is null 
          exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

        declare @APPUSERLINKID uniqueidentifier;
          set @APPUSERLINKID = (select ID from dbo.APPUSERCLAIMSLINK where APPUSERID = @ID);

        if @APPUSERLINKID is null 
          begin
            raiserror ('ERR_BBID_NOT_EXIST', 13, 1);
          end
        else
          begin
            exec dbo.USP_APPUSERCLAIMSLINK_DELETEBYID_WITHCHANGEAGENTID @APPUSERLINKID, @CHANGEAGENTID;
          end
        return 0;
      end