USP_DATALIST_FAFDEFAULTACKNOWLEDGEMENTS

CREATE procedure dbo.USP_DATALIST_FAFDEFAULTACKNOWLEDGEMENTS(@EVENTID uniqueidentifier)
as
    set nocount on;

  declare @ISREQUESTLINKON bit;

  select @ISREQUESTLINKON = COUNT(EVENTID)
  from dbo.EVENTTEAMFAFCONFIG 
  where EVENTID= @EVENTID AND (HOUSEHOLDAPPROVEBYEVENTADMIN = 1 OR TEAMSREQUESTFUNDRAISE = 1 OR COMPANYTEAMSAPPROVEBYEVENTADMIN = 1)
    select EET.ID,
           case EET.CONFIRMATIONTYPECODE
        when 1 then 'Registrant acknowledgement'
        when 2 then 'Sponsor acknowledgement'
        when 3 then 'Donor acknowledgement'
        when 6 then 'Contact acknowledgement'
        when 97 then 'Pending fundraising group request received'
        when 98 then 'Pending fundraising group request approved'
        when 99 then 'Pending fundraising group request declined' end
        as CONFIRMATIONTYPE,
           case EET.CONFIRMATIONTYPECODE
        when 97 then @ISREQUESTLINKON
        when 98 then @ISREQUESTLINKON
        when 99 then @ISREQUESTLINKON
        else 1 end
        as ISENABLE,

        ET.[SUBJECT]    

    from dbo.EVENTEMAILTEMPLATE EET
  join EMAILTEMPLATE ET ON EET.EMAILTEMPLATEID = ET.ID
    where EVENTID = @EVENTID and CONFIRMATIONTYPECODE in (1, 2, 3, 6, 97, 98, 99)