USP_DATALIST_GIFTAIDREFUNDREVENUE

                create procedure dbo.USP_DATALIST_GIFTAIDREFUNDREVENUE
                (
                    @REVENUEID uniqueidentifier
                )
                as
                    set nocount on;

                    declare @MULTICURRENCYENABLED bit;
                    set @MULTICURRENCYENABLED = dbo.UFN_CONDITIONSETTING_EVALUATEEXISTSCONDITION('Multicurrency');                    

                    select
                        REVENUESPLITGIFTAIDREFUND.ID,
                        REVENUESPLITGIFTAIDREFUND.REVENUESPLITID,
                        FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID,
                        ORIGINALTAXCLAIMNUMBER,
                        case @MULTICURRENCYENABLED
                            when 1 then REVENUESPLITGIFTAIDREFUND.ORIGINALTRANSACTIONTAXCLAIMAMOUNT
                            else REVENUESPLITGIFTAIDREFUND.ORIGINALTAXCLAIMAMOUNT
                        end as ORIGINALTAXCLAIMAMOUNT,
                        REVENUESPLITGIFTAIDREFUND.REFUNDTAXCLAIMNUMBER,
                        REVENUESPLITGIFTAIDREFUND.DATEREFUNDED,
                        REVENUESPLITGIFTAIDREFUND.REFUNDSOURCE,
                        REVENUESPLITGIFTAIDREFUND.REASON,
                        case @MULTICURRENCYENABLED
                            when 1 then FINANCIALTRANSACTION.TRANSACTIONCURRENCYID
                            else CURRENCYSET.BASECURRENCYID
                        end as DISPLAYCURRENCY
                    from
                        dbo.REVENUESPLITGIFTAIDREFUND
                        inner join dbo.FINANCIALTRANSACTIONLINEITEM on REVENUESPLITGIFTAIDREFUND.REVENUESPLITID = FINANCIALTRANSACTIONLINEITEM.ID
                        inner join dbo.REVENUESPLIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID
                        inner join dbo.FINANCIALTRANSACTION on FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION.ID
                        inner join dbo.REVENUE_EXT on FINANCIALTRANSACTION.ID = REVENUE_EXT.ID
                        inner join dbo.PDACCOUNTSYSTEM on FINANCIALTRANSACTION.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID
                        inner join dbo.CURRENCYSET on PDACCOUNTSYSTEM.CURRENCYSETID = CURRENCYSET.ID
                    where
                        FINANCIALTRANSACTION.ID = @REVENUEID