UFN_REVENUE_GETAPPLICATIONS

      CREATE function dbo.UFN_REVENUE_GETAPPLICATIONS
      (
        @TRANSACTIONID uniqueidentifier
      )
      returns @RESULT table
      (
        ID uniqueidentifier,
        APPLICATIONID uniqueidentifier,
        APPLICATIONCODE tinyint,
        APPLIED money,
        BALANCE money,
        AMOUNTDUE money,
        DATEDUE datetime,
        TYPECODE tinyint,
        APPLICATIONTRANSACTIONTYPECODE tinyint,
        DESCRIPTION nvarchar(255),
        GIFTFIELDS xml,
        OTHERFIELDS xml,
        MEMBERSHIPFIELDS xml,
        DECLINESGIFTAID bit default 0,
        GIFTAIDCOMMITTED bit default 0,
        ISGIFTAIDSPONSORSHIP bit default 0,
        TRANSACTIONCURRENCYID uniqueidentifier,
        APPLICATIONCURRENCYID uniqueidentifier,
        EXCHANGERATE decimal(20,8),
        RECURRINGGIFTFIELDS xml,
        CATEGORYCODEID uniqueidentifier default null
      )
      as
      begin
        --11/04/2014 Jason.Perry WI439722 Use modified version of the original GETAPPLICATIONS() to call GETAPPLICATIONS2() and denote we want to use

        --the "DESIGNATION.NAME" (parameter = 0) and not the "DESIGNATION.USERID" (parameter = 1). GETAPPLICATIONS2() is called from USP_PAYMENT_LOAD()

        insert into @RESULT 
        select * from dbo.[UFN_REVENUE_GETAPPLICATIONS_2](@TRANSACTIONID, 0);
        return;
      end