UFN_SITE_MAPFROM_APPEALMAILING

            create function dbo.UFN_SITE_MAPFROM_APPEALMAILING
            (
                @APPEALMAILINGID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin
                declare @SITEID uniqueidentifier;

                select top 1 
                    @SITEID = APPEAL.SITEID
                from dbo.APPEALMAILING
                inner join dbo.APPEAL on APPEALMAILING.APPEALID = APPEAL.ID
                where APPEALMAILING.ID = @APPEALMAILINGID;

                return @SITEID;
            end