UFN_SITEID_MAPFROM_ACCOUNTSYSTEM

CREATE function dbo.UFN_SITEID_MAPFROM_ACCOUNTSYSTEM
(@REVENUESPLITID uniqueidentifier) 
    returns uniqueidentifier
    as
    begin
        -- Note: Update UFN_SITEID_MAPFROM_REVENUESPLITID if the below logic is changed


        declare @ID uniqueidentifier;

    select top 1 @ID = a.SITEID
    from dbo.PDACCOUNTSYSTEMSITE as a
    inner join dbo.FINANCIALTRANSACTION as b on a.PDACCOUNTSYSTEMID = b.PDACCOUNTSYSTEMID
    inner join dbo.FINANCIALTRANSACTIONLINEITEM as c on b.ID = c.FINANCIALTRANSACTIONID
    inner join dbo.PDACCOUNTSYSTEM as d on b.PDACCOUNTSYSTEMID = d.ID
    where c.ID = @REVENUESPLITID

        return @ID;

    end