UFN_PLANNEDGIFTADDITION_GETPAYMENTS

          CREATE function dbo.UFN_PLANNEDGIFTADDITION_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.PLANNEDGIFTADDITION PGA
              inner join dbo.PLANNEDGIFTADDITIONREVENUE PGAR on PGA.ID = PGAR.ID
              inner join dbo.REVENUE on PGAR.REVENUEID = REVENUE.ID
              inner join INSTALLMENTSPLITPAYMENT on INSTALLMENTSPLITPAYMENT.PLEDGEID=REVENUE.ID
              inner join dbo.REVENUESPLIT on INSTALLMENTSPLITPAYMENT.PAYMENTID = REVENUESPLIT.ID
              where PGA.ID = @ID

              return @PAYMENTS
          end