UFN_SITEID_MAPFROM_REVENUEID

            CREATE function dbo.UFN_SITEID_MAPFROM_REVENUEID
            (
                @REVENUEID uniqueidentifier
            )
            returns table
            as
            return
                select distinct SITES.SITEID
                from dbo.FINANCIALTRANSACTIONLINEITEM
                cross apply dbo.UFN_SITEID_MAPFROM_REVENUESPLITID(FINANCIALTRANSACTIONLINEITEM.ID) SITES
                where FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @REVENUEID
                and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null