fnGetExclusionEmailAddresses

            CREATE FUNCTION [dbo].[fnGetExclusionEmailAddresses](@AppealID INT)
            RETURNS TABLE AS RETURN

            SELECT DISTINCT ep.EmailAddress FROM EmailProjectAppeal_EmailList epael
                INNER JOIN EmailList_People ep on epael.EmailListID = ep.EmailListID
                WHERE epael.EmailProjectAppealID = @AppealID AND epael.AppealListType = 3
                AND IsNull(ep.EmailAddress,'') <> ''

        UNION ALL

            SELECT DISTINCT ml.EmailAddress FROM EmailProjectAppeal_EmailList epael
                INNER JOIN EmailListUploadMasterList ml on epael.EmailListID = ml.EmailListID
                WHERE epael.EmailProjectAppealID = @AppealID AND epael.AppealListType = 3
                AND IsNull(ml.EmailAddress,'') <> ''

        UNION ALL

            SELECT DISTINCT eud.EmailAddress FROM EmailProjectAppeal_EmailList epael
                INNER JOIN EmailList_UserDefined eud on epael.EmailListID = eud.EmailListID
                WHERE epael.EmailProjectAppealID = @AppealID AND epael.AppealListType = 3
                AND IsNull(eud.EmailAddress,'') <> ''