UFN_REVENUESPLITGIFTAID_GETELIGIBLE_2

            CREATE function dbo.UFN_REVENUESPLITGIFTAID_GETELIGIBLE_2
            (
                @ACTUALONLY bit,
                @CURRENCYTYPE tinyint = 0 -- 0 = Base, 1 = Transaction, 2 = Organization

            )
            returns table
            as
            return
            (
                select
                    REVENUESPLITGIFTAID.ID,
                    case FINANCIALTRANSACTION.TYPECODE
                         when 1 then coalesce(PLEDGETAXCLAIM.BASETAXCLAIMAMOUNT,0) + coalesce(PLEDGETAXCLAIM.TRANSITIONALTAXCLAIMAMOUNT,0)
                         when 2 then dbo.UFN_GIFTAIDREVENUESPLIT_CALCULATENEXTCLAIMAMOUNT_2(REVENUESPLITGIFTAID.ID, @CURRENCYTYPE) 
                         else
                                case @CURRENCYTYPE 
                                    when 0 then REVENUESPLITGIFTAID.TAXCLAIMAMOUNT
                                    when 1 then REVENUESPLITGIFTAID.TRANSACTIONTAXCLAIMAMOUNT
                                    when 2 then REVENUESPLITGIFTAID.ORGANIZATIONTAXCLAIMAMOUNT
                                end
                    end as TAXCLAIMAMOUNT,
                    TAXCLAIMNUMBER,
                    REVENUESPLITGIFTAID.BASETAXCLAIMAMOUNT,
                    REVENUESPLITGIFTAID.TRANSITIONALTAXCLAIMAMOUNT,
                    INCLUDETRANSITIONALAMOUNTCODE
                from dbo.REVENUESPLITGIFTAID
                inner join dbo.FINANCIALTRANSACTIONLINEITEM on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLITGIFTAID.ID
                inner join dbo.FINANCIALTRANSACTION on FINANCIALTRANSACTION.ID = FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID
                cross apply dbo.UFN_GIFTAIDREVENUESPLIT_CALCULATEPLEDGETAXCLAIMAMOUNT_2(REVENUESPLITGIFTAID.ID,@CURRENCYTYPE) as PLEDGETAXCLAIM
                where
                FINANCIALTRANSACTION.TYPECODE in (0,1,2,3,4,5,6,7,8,9,15) 
                and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null 
                and FINANCIALTRANSACTIONLINEITEM.TYPECODE != 1 and
                (
                    @ACTUALONLY = 1 and
                    (RULES_STATUS & ATTRIBUTES_STATUS) = 1 and DECLINESGIFTAID = 0 and
                    dbo.UFN_GIFTAIDREVENUESPLIT_ISTAXCLAIMELIGIBILE(REVENUESPLITGIFTAID.ID) = 1
                ) or
                (
                    @ACTUALONLY = 0 and
                    (RULES_STATUS & ATTRIBUTES_STATUS) = 1 and
                    dbo.UFN_GIFTAIDREVENUESPLIT_GETTAXCLAIMELIGIBILITYSTATUS(REVENUESPLITGIFTAID.ID) != 1
                )

            )