spGetAppealLists_MessagesStep

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

as

    BEGIN
            SELECT el.[ID] "EmailListID"
                          ,el.[ClientsID]
                          ,el.[OwnerID]
                          ,el.[Name]
                          ,el.[Description]
                          ,el.[type]
                          ,el.[DataSourceID]
                          ,el.[Origin]
                          ,epal.[AppealListType]
                          ,epal.[EmailProjectAppealID]
                          ,epal.[ID] "AppealEmailListID"
                          ,dbo.fnGetAppealListFinalEmailStatus(epal.[ID]) as FinalMailStatus
                       FROM [dbo].[EmailProjectAppeal_EmailList] epal inner join [dbo].[EmailList] el on epal.EmailListID = el.[ID]
                       WHERE epal.[EmailProjectAppealID] = @EmailProjectAppealID AND 
                        (el.AcquiredStatus = 1 OR [dbo].fnIsProjectComponentLinked(0,0,epal.[ID],0) = 1)
                       AND epal.[AppealListType] = 1
                       AND epal.Deleted = 0
     END