UFN_SITEID_MAPFROM_APPEALBENEFITID

        create function dbo.UFN_SITEID_MAPFROM_APPEALBENEFITID(@APPEALBENEFITID uniqueidentifier) 
        returns uniqueidentifier
        as
        begin

            DECLARE @ID uniqueidentifier;

            SELECT @ID=APPEAL.SITEID from dbo.APPEALBENEFIT
            inner join dbo.APPEAL on APPEALBENEFIT.APPEALID = APPEAL.ID
            where APPEALBENEFIT.ID=@APPEALBENEFITID;

            RETURN @ID;

        end