UFN_SITEID_MAPFROM_REVENUERECOGNITIONID

             CREATE function dbo.UFN_SITEID_MAPFROM_REVENUERECOGNITIONID  
             (  
            @RECOGNITIONID uniqueidentifier  
             )   
             returns table
             as  
            return
                (
                    select distinct SITES.SITEID
                    from dbo.REVENUERECOGNITION
                    cross apply dbo.UFN_SITEID_MAPFROM_REVENUESPLITID(REVENUERECOGNITION.REVENUESPLITID) SITES
                    where REVENUERECOGNITION.ID = @RECOGNITIONID
                )