UFN_CORPORATION_GETCONSTITUENTRECOGNITIONINCURRENCY

            CREATE function [dbo].[UFN_CORPORATION_GETCONSTITUENTRECOGNITIONINCURRENCY](@CURRENTAPPUSERID uniqueidentifier, @ROOTID uniqueidentifier, @CURRENCYID uniqueidentifier)
            returns table
            as return
            select
                CSS.SELECTEDID as CONSTITUENTID,
                RR.ID as RECOGNITIONID,
                R.ID as REVENUEID,
                sum(RR.AMOUNTINCURRENCY) as AMOUNT,
                RS.ID as REVENUESPLITID,
                R.TRANSACTIONTYPECODE as TRANSACTIONTYPECODE,
                RS.APPLICATIONCODE as APPLICATIONCODE,
                RS.TYPECODE as TYPECODE
            from
                dbo.CORPORATESTRUCTURESELECTION CSS
                inner join dbo.UFN_RECOGNITIONCREDIT_GETRECOGNITIONS(1, null, @CURRENCYID) RR on RR.CONSTITUENTID = CSS.SELECTEDID
                inner join dbo.REVENUESPLIT RS on RS.ID = RR.REVENUESPLITID
                inner join dbo.REVENUE R on R.ID = RS.REVENUEID
                inner join (select distinct REVENUEID from dbo.UFN_SITEACCESSABLE_REVENUESPLITID_FORUSER(@CURRENTAPPUSERID)) SITEFILTER on SITEFILTER.REVENUEID = R.ID
                cross apply dbo.UFN_CORPORATION_GETFILTERDATES(@CURRENTAPPUSERID) DF
            where
                ((DF.STARTDATE is null or DF.STARTDATE <= RR.EFFECTIVEDATE)
                    and
                    (DF.ENDDATE is null or DF.ENDDATE >= RR.EFFECTIVEDATE)) and
                CSS.APPUSERID = @CURRENTAPPUSERID and
                CSS.ROOTID = @ROOTID
            group by CSS.SELECTEDID, RR.ID, R.ID, RS.ID, R.TRANSACTIONTYPECODE, RS.APPLICATIONCODE, RS.TYPECODE;