UFN_SITEID_MAPFROM_REVENUECOMMITMENTID

CREATE function dbo.UFN_SITEID_MAPFROM_REVENUECOMMITMENTID
(
    @REVENUECOMMITMENTID uniqueidentifier
)
returns table
as
return
    select distinct
        DATA.SITEID
    from
    (
        select 
            SITES.SITEID
        from 
            dbo.REVENUESPLIT
            cross apply dbo.UFN_SITEID_MAPFROM_REVENUESPLITID(REVENUESPLIT.ID) SITES
        where 
            REVENUESPLIT.REVENUEID = @REVENUECOMMITMENTID

        union all

        select 
            SITES.SITEID
        from
            dbo.UFN_SITEID_MAPFROM_OPPORTUNITYID(@REVENUECOMMITMENTID) SITES

    ) as DATA