USP_SIMPLEDATALIST_FAFDEFAULTACKNOWLEDGEMENTS

CREATE procedure dbo.USP_SIMPLEDATALIST_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 ET.ID AS VALUE,
      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 LABEL
    from dbo.EVENTEMAILTEMPLATE EET
  join EMAILTEMPLATE ET ON EET.EMAILTEMPLATEID = ET.ID
    where EVENTID = @EVENTID and 
  ((@ISREQUESTLINKON=1 and CONFIRMATIONTYPECODE in (97, 98, 99)) or (CONFIRMATIONTYPECODE in (1, 2, 3, 6)))