UFN_CORPORATION_GETCONSTITUENTRECOGNITION

            CREATE function [dbo].[UFN_CORPORATION_GETCONSTITUENTRECOGNITION](@CURRENTAPPUSERID uniqueidentifier, @ROOTID uniqueidentifier)
            returns table
            as return

            select
                CSS.SELECTEDID as CONSTITUENTID,
                RR.ID as RECOGNITIONID,
                R.ID as REVENUEID,
                sum(RR.AMOUNT) as AMOUNT,
                RS.ID as REVENUESPLITID,
                R.TYPECODE as TRANSACTIONTYPECODE,
                RSE.APPLICATIONCODE as APPLICATIONCODE,
                RSE.TYPECODE as TYPECODE
            from
                dbo.CORPORATESTRUCTURESELECTION CSS
                inner join dbo.REVENUERECOGNITION RR on RR.CONSTITUENTID = CSS.SELECTEDID 
                inner join dbo.FINANCIALTRANSACTIONLINEITEM RS on RS.ID = RR.REVENUESPLITID
                inner join dbo.REVENUESPLIT_EXT RSE on RSE.ID = RS.ID
                inner join dbo.FINANCIALTRANSACTION R on R.ID = RS.FINANCIALTRANSACTIONID
                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 and
                R.DELETEDON is null and
                RS.DELETEDON is null and
                RS.TYPECODE <> 1
            group by CSS.SELECTEDID, RR.ID, R.ID, RS.ID, R.TYPECODE, RSE.APPLICATIONCODE, RSE.TYPECODE