UFN_CORPORATION_GETCONSTITUENTRECOGNITIONINCURRENCY_NOSITE

CREATE function dbo.UFN_CORPORATION_GETCONSTITUENTRECOGNITIONINCURRENCY_NOSITE
(
    @CURRENTAPPUSERID uniqueidentifier, 
    @ROOTID uniqueidentifier, 
    @CURRENCYID uniqueidentifier,
    @SECURITYFEATUREID uniqueidentifier,
    @SECURITYFEATURETYPE tinyint
)
returns table
as return
select
    CSS.SELECTEDID as CONSTITUENTID,
    RR.ID as RECOGNITIONID,
    RR.REVENUEID,
    sum(RR.AMOUNTINCURRENCY) as AMOUNT,
    RR.REVENUESPLITID,
    RR.TRANSACTIONTYPECODE,
    RR.APPLICATIONCODE,
    RR.REVENUESPLITTYPECODE as TYPECODE
from
    dbo.CORPORATESTRUCTURESELECTION CSS
    inner join dbo.UFN_RECOGNITIONCREDIT_GETRECOGNITIONS_4(1, null, @CURRENCYID, @ROOTID, @CURRENTAPPUSERID) RR on RR.CONSTITUENTID = CSS.SELECTEDID
    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, RR.REVENUEID, RR.REVENUESPLITID, RR.TRANSACTIONTYPECODE, RR.APPLICATIONCODE, RR.REVENUESPLITTYPECODE;