UFN_PLANNEDGIFTREVENUE_GETTOTALAMOUNT

          CREATE function dbo.UFN_PLANNEDGIFTREVENUE_GETTOTALAMOUNT
          (
            @PLANNEDGIFTID 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, PG.TRANSACTIONGIFTAMOUNT)
                when 1 then coalesce(REVENUE.ORGANIZATIONAMOUNT, PG.ORGANIZATIONGIFTAMOUNT)
                when 3 then  
                  case when REVENUE.ID is null 
                  then dbo.UFN_PLANNEDGIFTDESIGNATION_AMOUNTINCURRENCY(PG.ID, @CURRENCYID) 
                  else dbo.UFN_REVENUE_GETAMOUNTINCURRENCY(REVENUE.ID, @CURRENCYID) end
                else coalesce(REVENUE.AMOUNT, PG.GIFTAMOUNT)
              end
            from dbo.PLANNEDGIFT PG
            left join dbo.PLANNEDGIFTREVENUE PGR on PG.ID = PGR.ID
            left join dbo.REVENUE on PGR.REVENUEID = REVENUE.ID
            where PG.ID = @PLANNEDGIFTID

            return @AMOUNT
          end