USP_DATALIST_EVENTEMAILTEMPLATE

Returns email template ID for a FAF event

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	Event ID
@CONFIRMATIONTYPECODE	tinyint	IN	Email Category Code

Definition

Copy




CREATE procedure dbo.USP_DATALIST_EVENTEMAILTEMPLATE
(
@EVENTID uniqueidentifier
, @CONFIRMATIONTYPECODE tinyint
)
as
    set nocount on;

    SELECT EE.ID,
          EE.EMAILTEMPLATEID,
          ET.NAME, 
          ET.SUBJECT,
          ET.FROMDISPLAYNAME,
          ET.FROMADDRESS,
          ET.TYPE,
          ET.CONTENTHTML,
          ET.CONTENTTEXT,
          ET.REPLYADDRESS
    FROM dbo.EVENTEMAILTEMPLATE EE (NOLOCK)
    INNER JOIN dbo.EMAILTEMPLATE ET (NOLOCK)
    ON ET.ID = EE.EMAILTEMPLATEID

    WHERE EE.EVENTID = @EVENTID
    AND EE.CONFIRMATIONTYPECODE = @CONFIRMATIONTYPECODE