UFN_CONSTITUENTRECOGNITIONREVENUE_GETAMOUNTINCURRENCY_BULK

            CREATE function [dbo].[UFN_CONSTITUENTRECOGNITIONREVENUE_GETAMOUNTINCURRENCY_BULK]
            (
                @CURRENCYID uniqueidentifier,
                @ORGANIZATIONCURRENCYID uniqueidentifier,
                @DECIMALDIGITS tinyint,
                @ROUNDINGTYPECODE tinyint
            )
            returns table
            as
            return
            (
                select
                    CONSTITUENTRECOGNITIONREVENUE.ID,
                    CONSTITUENTRECOGNITIONREVENUE.RECOGNITIONPROGRAMID,
                    CONSTITUENTRECOGNITIONREVENUE.REVENUERECOGNITIONID,
                    case
                        when (@CURRENCYID is null) or (@CURRENCYID = @ORGANIZATIONCURRENCYID)
                            then CONSTITUENTRECOGNITIONREVENUE.ORGANIZATIONAMOUNT
                        else
                            CONSTITUENTRECOGNITIONREVENUE.AMOUNT
                    end [AMOUNTINCURRENCY],
                    CONSTITUENTRECOGNITIONREVENUE.EFFECTIVEDATE,
                    CONSTITUENTRECOGNITIONREVENUE.ISPLANNEDGIFT,
                    CONSTITUENTRECOGNITIONREVENUE.DATEADDED [CONSTITUENTRECOGNITIONREVENUEDATEADDED],
                    CONSTITUENTRECOGNITIONREVENUE.TSLONG,
                    CONSTITUENTRECOGNITIONREVENUE.RECOGNITIONCREDITID
                from
                    dbo.CONSTITUENTRECOGNITIONREVENUE
                where (@CURRENCYID is null) 
                    or (@CURRENCYID = @ORGANIZATIONCURRENCYID)
                    or @CURRENCYID = CONSTITUENTRECOGNITIONREVENUE.BASECURRENCYID

                union all

                select
                    CONSTITUENTRECOGNITIONREVENUE.ID,
                    CONSTITUENTRECOGNITIONREVENUE.RECOGNITIONPROGRAMID,
                    CONSTITUENTRECOGNITIONREVENUE.REVENUERECOGNITIONID,
                    case
                        when [LATESTORGANIZATIONEXCHANGERATE].RATE is not null
                            then dbo.UFN_CURRENCY_ROUND(dbo.UFN_CURRENCY_APPLYRATE(CONSTITUENTRECOGNITIONREVENUE.ORGANIZATIONAMOUNT, [LATESTORGANIZATIONEXCHANGERATE].RATE), @DECIMALDIGITS, @ROUNDINGTYPECODE)

                        when [LATESTINVERSEORGANIZATIONEXCHANGERATE].RATE is not null
                            then dbo.UFN_CURRENCY_ROUND(dbo.UFN_CURRENCY_APPLYRATE(CONSTITUENTRECOGNITIONREVENUE.ORGANIZATIONAMOUNT, cast((1 / [LATESTINVERSEORGANIZATIONEXCHANGERATE].RATE) as decimal(20,8))), @DECIMALDIGITS, @ROUNDINGTYPECODE)

                        else
                            0
                    end [AMOUNTINCURRENCY],
                    CONSTITUENTRECOGNITIONREVENUE.EFFECTIVEDATE,
                    CONSTITUENTRECOGNITIONREVENUE.ISPLANNEDGIFT,
                    CONSTITUENTRECOGNITIONREVENUE.DATEADDED [CONSTITUENTRECOGNITIONREVENUEDATEADDED],
                    CONSTITUENTRECOGNITIONREVENUE.TSLONG,
                    CONSTITUENTRECOGNITIONREVENUE.RECOGNITIONCREDITID
                from
                    dbo.CONSTITUENTRECOGNITIONREVENUE
                    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 CONSTITUENTRECOGNITIONREVENUE.EFFECTIVEDATE >= CURRENCYEXCHANGERATE.ASOFDATE
                            and CONSTITUENTRECOGNITIONREVENUE.EFFECTIVEDATE <= CURRENCYEXCHANGERATE.NEXTRATEASOFDATEORMAX
                    ) 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 CONSTITUENTRECOGNITIONREVENUE.EFFECTIVEDATE >= CURRENCYEXCHANGERATE.ASOFDATE
                            and CONSTITUENTRECOGNITIONREVENUE.EFFECTIVEDATE <= CURRENCYEXCHANGERATE.NEXTRATEASOFDATEORMAX
                    ) LATESTINVERSEORGANIZATIONEXCHANGERATE
                    where (@CURRENCYID is not null) 
                        and (@CURRENCYID <> @ORGANIZATIONCURRENCYID)
                        and @CURRENCYID <> CONSTITUENTRECOGNITIONREVENUE.BASECURRENCYID    
            )