UFN_EVENTEXPENSE_GETINCURRENCY_BULK

            CREATE function dbo.UFN_EVENTEXPENSE_GETINCURRENCY_BULK
            (
                @CURRENCYID uniqueidentifier,
                @ORGANIZATIONCURRENCYID uniqueidentifier,
                @DECIMALDIGITS tinyint,
                @ROUNDINGTYPECODE tinyint
            )
            returns table
            as 
            return(
                select 
                    EVENTEXPENSE.ID,
                    EVENTEXPENSE.EVENTID,
                    case
                        when (@CURRENCYID is null) or (@CURRENCYID = @ORGANIZATIONCURRENCYID)
                            then EVENTEXPENSE.ORGANIZATIONACTUALAMOUNT
                        else
                            EVENTEXPENSE.ACTUALAMOUNT
                    end [ACTUALAMOUNTINCURRENCY],
                    case
                        when (@CURRENCYID is null) or (@CURRENCYID = @ORGANIZATIONCURRENCYID)
                            then EVENTEXPENSE.ORGANIZATIONAMOUNTPAID
                        else
                            EVENTEXPENSE.AMOUNTPAID
                    end [AMOUNTPAIDINCURRENCY],
                    case
                        when (@CURRENCYID is null) or (@CURRENCYID = @ORGANIZATIONCURRENCYID)
                            then EVENTEXPENSE.ORGANIZATIONBUDGETEDAMOUNT
                        else
                            EVENTEXPENSE.BUDGETEDAMOUNT
                    end [BUDGETEDAMOUNTINCURRENCY]
                from dbo.EVENTEXPENSE
                where (@CURRENCYID is null) 
                    or (@CURRENCYID = @ORGANIZATIONCURRENCYID)
                    or @CURRENCYID = EVENTEXPENSE.BASECURRENCYID

                union all

                select
                    EVENTEXPENSE.ID,
                    EVENTEXPENSE.EVENTID,
                    case
                        when [LATESTORGANIZATIONEXCHANGERATE].RATE is not null
                            then dbo.UFN_CURRENCY_ROUND(dbo.UFN_CURRENCY_APPLYRATE(EVENTEXPENSE.ORGANIZATIONACTUALAMOUNT, [LATESTORGANIZATIONEXCHANGERATE].RATE), @DECIMALDIGITS, @ROUNDINGTYPECODE)
                        when [LATESTINVERSEORGANIZATIONEXCHANGERATE].RATE is not null
                            then dbo.UFN_CURRENCY_ROUND(dbo.UFN_CURRENCY_APPLYRATE(EVENTEXPENSE.ORGANIZATIONACTUALAMOUNT, cast((1 / [LATESTINVERSEORGANIZATIONEXCHANGERATE].RATE) as decimal(20,8))), @DECIMALDIGITS, @ROUNDINGTYPECODE)
                        else
                            0
                    end [ACTUALAMOUNTINCURRENCY],
                    case
                        when [LATESTORGANIZATIONEXCHANGERATE].RATE is not null
                            then dbo.UFN_CURRENCY_ROUND(dbo.UFN_CURRENCY_APPLYRATE(EVENTEXPENSE.ORGANIZATIONAMOUNTPAID, [LATESTORGANIZATIONEXCHANGERATE].RATE), @DECIMALDIGITS, @ROUNDINGTYPECODE)
                        when [LATESTINVERSEORGANIZATIONEXCHANGERATE].RATE is not null
                            then dbo.UFN_CURRENCY_ROUND(dbo.UFN_CURRENCY_APPLYRATE(EVENTEXPENSE.ORGANIZATIONAMOUNTPAID, cast((1 / [LATESTINVERSEORGANIZATIONEXCHANGERATE].RATE) as decimal(20,8))), @DECIMALDIGITS, @ROUNDINGTYPECODE)
                        else
                            0
                    end [AMOUNTPAIDINCURRENCY],
                    case
                        when [LATESTORGANIZATIONEXCHANGERATE].RATE is not null
                            then dbo.UFN_CURRENCY_ROUND(dbo.UFN_CURRENCY_APPLYRATE(EVENTEXPENSE.ORGANIZATIONBUDGETEDAMOUNT, [LATESTORGANIZATIONEXCHANGERATE].RATE), @DECIMALDIGITS, @ROUNDINGTYPECODE)
                        when [LATESTINVERSEORGANIZATIONEXCHANGERATE].RATE is not null
                            then dbo.UFN_CURRENCY_ROUND(dbo.UFN_CURRENCY_APPLYRATE(EVENTEXPENSE.ORGANIZATIONBUDGETEDAMOUNT, cast((1 / [LATESTINVERSEORGANIZATIONEXCHANGERATE].RATE) as decimal(20,8))), @DECIMALDIGITS, @ROUNDINGTYPECODE)
                        else
                            0
                    end [BUDGETEDAMOUNTINCURRENCY]
                from dbo.EVENTEXPENSE

                outer apply
                    (
                        select
                            RATE
                        from
                            dbo.CURRENCYEXCHANGERATE
                        where
                            @ORGANIZATIONCURRENCYID = CURRENCYEXCHANGERATE.FROMCURRENCYID
                            and @CURRENCYID = CURRENCYEXCHANGERATE.TOCURRENCYID
                            and CURRENCYEXCHANGERATE.TYPECODE in (0,1)
                            and CURRENCYEXCHANGERATE.ISLATESTRATEFORASOFDATE = 1
                            and EVENTEXPENSE.DATEADDED >= CURRENCYEXCHANGERATE.ASOFDATESDTZ
                            and EVENTEXPENSE.DATEADDED <= CURRENCYEXCHANGERATE.NEXTRATEASOFDATEORMAXSDTZ
                    ) LATESTORGANIZATIONEXCHANGERATE

                outer apply
                    (
                        select
                            RATE
                 from
                            dbo.CURRENCYEXCHANGERATE
                        where
                            @CURRENCYID = CURRENCYEXCHANGERATE.FROMCURRENCYID
                            and @ORGANIZATIONCURRENCYID= CURRENCYEXCHANGERATE.TOCURRENCYID
                            and CURRENCYEXCHANGERATE.TYPECODE in (0,1)
                            and CURRENCYEXCHANGERATE.ISLATESTRATEFORASOFDATE = 1
                            and EVENTEXPENSE.DATEADDED >= CURRENCYEXCHANGERATE.ASOFDATESDTZ
                            and EVENTEXPENSE.DATEADDED <= CURRENCYEXCHANGERATE.NEXTRATEASOFDATEORMAXSDTZ
                    ) LATESTINVERSEORGANIZATIONEXCHANGERATE

                where (@CURRENCYID is not null) 
                and (@CURRENCYID <> @ORGANIZATIONCURRENCYID)
                and @CURRENCYID <> EVENTEXPENSE.BASECURRENCYID

            );