USP_CHARGE_UNAPPLYALL

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

            declare @APPLICATIONSXML xml;

            begin try
              -- Get the items to reverse

              set @APPLICATIONSXML = 
                  (select FINANCIALTRANSACTIONLINEITEM_APPLICATION.ID as ID
                  from dbo.FINANCIALTRANSACTIONLINEITEM as FINANCIALTRANSACTIONLINEITEM_APPLICATION
                      inner join dbo.FINANCIALTRANSACTIONLINEITEM
                          on FINANCIALTRANSACTIONLINEITEM.ID = FINANCIALTRANSACTIONLINEITEM_APPLICATION.TARGETLINEITEMID
                  where (FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @ID) and 
                        (FINANCIALTRANSACTIONLINEITEM.TYPECODE = 0) and
                (FINANCIALTRANSACTIONLINEITEM.DELETEDON is null) and 
                (FINANCIALTRANSACTIONLINEITEM_APPLICATION.DELETEDON is null)
                for xml raw('ITEM'),type,elements,root('APPLICATIONS'),BINARY BASE64);

                -- Unapply the items

                exec dbo.USP_FINANCIALTRANSACTION_LINEITEMAPPLICATIONS_UNAPPLYMULTIPLE @APPLICATIONSXML, @CHANGEAGENTID;

            end try

            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch

            return 0;
        end