USP_SIMPLEDATALIST_PARTICIPANTCOMMUNICATIONTEMPLATES

CREATE procedure dbo.USP_SIMPLEDATALIST_PARTICIPANTCOMMUNICATIONTEMPLATES(@EVENTID uniqueidentifier) as
        select
            ET.ID AS VALUE
            ,ET.SUBJECT as LABEL
        from dbo.EVENTEMAILTEMPLATE EET
        join EMAILTEMPLATE ET ON EET.EMAILTEMPLATEID = ET.ID
        where EET.EVENTID = @EVENTID and EET.CONFIRMATIONTYPECODE = 100