UFN_GIFTAIDREVENUESPLIT_GETTAXCLAIMAMOUNTCONSIDERPOTENTIAL

            CREATE FUNCTION UFN_GIFTAIDREVENUESPLIT_GETTAXCLAIMAMOUNTCONSIDERPOTENTIAL 
      (
          @ID uniqueidentifier
      )
      RETURNS money
      AS
      BEGIN
          DECLARE @TAXCLAIMAMOUNT money
          DECLARE @SHOWPOTENTIAL bit

          --Gift Aid is for UK only

        if dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('9568A6C2-F7AA-45fd-8F54-21FE9654EE2D') = 1
           begin
              select @SHOWPOTENTIAL = dbo.UFN_GIFTAIDREVENUESPLIT_SHOWTOTALSASPOTENTIAL(@ID)
              -- If the tax claim amount shows as potential because there isn't a valid declaration, 

              -- only include splits that don't have a valid declaration so that covenant gifts are excluded

              if @SHOWPOTENTIAL = 1
                select @TAXCLAIMAMOUNT = coalesce(sum(TRANSACTIONTAXCLAIMAMOUNT), 0)
                from dbo.REVENUESPLITGIFTAID
                inner join dbo.REVENUESPLIT on REVENUESPLITGIFTAID.ID = REVENUESPLIT.ID
                where
                  REVENUESPLIT.REVENUEID = @ID and
                  (REVENUESPLITGIFTAID.RULES_STATUS & REVENUESPLITGIFTAID.ATTRIBUTES_STATUS) = 1 and
                  dbo.UFN_GIFTAIDREVENUESPLIT_GETTAXCLAIMELIGIBILITY(REVENUESPLIT.ID) = 'No valid declaration'
              else
                    set @TAXCLAIMAMOUNT = dbo.UFN_GIFTAIDREVENUESPLIT_GETTAXCLAIMAMOUNT_2(@ID, 0, 1)
           end
        else
           begin
                set @TAXCLAIMAMOUNT = 0
           end

          RETURN @TAXCLAIMAMOUNT
      END