spGetEmailProjectAppealEmailByEmail

    CREATE PROCEDURE [dbo].[spGetEmailProjectAppealEmailByEmail]
            @EmailID int

            as

            SELECT epale.[ID]
              FROM [dbo].[EmailProjectAppeal_ListEmail] epale
              inner join Email e on e.ProjectAppealListEmailID = epale.[ID]
              WHERE e.[ID] = @EmailID