UFN_PLANNEDGIFT_GETPAYMENTS

          CREATE function dbo.UFN_PLANNEDGIFT_GETPAYMENTS
          (
            @ID uniqueidentifier,
            @CURRENCYID uniqueidentifier,
            @CURRENCYCODE tinyint = 2
          )
          returns money
          with execute as caller
          as begin
              declare @PAYMENTS money = 0;

              select @PAYMENTS = sum(
                case @CURRENCYCODE
                  when 2 then INSTALLMENTSPLITPAYMENT.AMOUNT
                  when 1 then REVENUESPLIT.ORGANIZATIONAMOUNT
                  when 3 then dbo.UFN_REVENUESPLIT_GETAMOUNTINCURRENCY(REVENUESPLIT.ID, @CURRENCYID)
                  else REVENUESPLIT.AMOUNT
                end)
              from dbo.PLANNEDGIFT PG
              inner join dbo.PLANNEDGIFTREVENUE PGR on PG.ID = PGR.ID
              inner join dbo.REVENUE on PGR.REVENUEID = REVENUE.ID
              inner join INSTALLMENTSPLITPAYMENT on INSTALLMENTSPLITPAYMENT.PLEDGEID=REVENUE.ID
              inner join dbo.REVENUESPLIT on INSTALLMENTSPLITPAYMENT.PAYMENTID = REVENUESPLIT.ID
              where PG.ID = @ID

              return @PAYMENTS
          end