spGetAppealLists_SendTestStep

    CREATE  PROCEDURE [dbo].[spGetAppealLists_SendTestStep]
@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]
          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