spGetAppealListFinalEmail

        CREATE PROCEDURE dbo.spGetAppealListFinalEmail
@ProjectAppealListID int

as

SELECT ej.[Status], e.[ID] as EmailID, e.[Subject], e.[Name], e.[FromDisplayName], epale.[ID],epale.[EmailProjectAppealListID]
FROM EmailJob ej 
INNER JOIN Email e on ej.EmailID = e.[ID]
INNER JOIN EmailProjectAppeal_ListEmail epale on e.[ProjectAppealListEmailID] = epale.[ID]
WHERE e.[Type] = 8 AND epale.[EmailProjectAppealListID] = @ProjectAppealListID