UFN_PLANNEDGIFTADDITIONREVENUE_GETTOTALAMOUNT

          CREATE function dbo.UFN_PLANNEDGIFTADDITIONREVENUE_GETTOTALAMOUNT
          (
            @PLANNEDGIFTADDITIONID uniqueidentifier,
            @CURRENCYCODE int = 2,
            @CURRENCYID uniqueidentifier = null
          )
          returns money
          with execute as caller
          as begin 
            declare @AMOUNT as money

            select @AMOUNT = 
              case @CURRENCYCODE
                when 2 then coalesce(REVENUE.TRANSACTIONAMOUNT, PGA.TRANSACTIONGIFTAMOUNT)
                when 1 then coalesce(REVENUE.ORGANIZATIONAMOUNT, PGA.ORGANIZATIONGIFTAMOUNT)
                when 3 then  
                  case when REVENUE.ID is null 
                  then dbo.UFN_PLANNEDGIFTADDITIONDESIGNATION_AMOUNTINCURRENCY(PGA.ID, @CURRENCYID)
                  else dbo.UFN_REVENUE_GETAMOUNTINCURRENCY(REVENUE.ID, @CURRENCYID) end
                else coalesce(REVENUE.AMOUNT, PGA.GIFTAMOUNT)
              end
            from dbo.PLANNEDGIFTADDITION PGA
            left join dbo.PLANNEDGIFTADDITIONREVENUE PGAR on PGA.ID = PGAR.ID
            left join dbo.REVENUE on PGAR.REVENUEID = REVENUE.ID
            where PGA.ID = @PLANNEDGIFTADDITIONID

            return @AMOUNT
          end