spGetAppealLists_SendFinalStep

    CREATE  PROCEDURE [dbo].[spGetAppealLists_SendFinalStep]
@EmailProjectAppealID int

as

SELECT el.[ID] "EmailListID"
                      ,el.[ClientsID]
                      ,el.[OwnerID]
                      ,el.[Name]
                      ,el.[Description]
                      ,el.[type]
                      ,el.[DataSourceID]
                      ,epal.[AppealListType]
                      ,epal.[EmailProjectAppealID]
                      ,epal.[ID] "AppealEmailListID"
                      ,el.[Origin]
                      ,dbo.fnGetAppealListFinalEmailStatus(epal.[ID])
          FROM [dbo].[EmailProjectAppeal_EmailList] epal inner join [dbo].[EmailList] el on epal.EmailListID = el.[ID]
          WHERE epal.[EmailProjectAppealID] = @EmailProjectAppealID AND epal.AppealListType = 1 
          AND [dbo].fnIsProjectComponentLinked(0,0,epal.[ID],0) = 1
          AND epal.Deleted = 0 AND EXISTS(SELECT NULL FROM EmailJob ej 
          INNER JOIN Email e on ej.EmailID = e.ID
          INNER JOIN EmailProjectAppeal_ListEmail epale on e.ProjectAppealListEmailID = epale.ID    
          AND epale.EmailProjectAppealListID = epal.ID)