How to identify the incorrect ( error

Help
1

{%- call statement(‘rec_count’, fetch_result=True) -%}
{%- call statement(‘my_statement’, fetch_result=True) -%}
select ‘.VA_Lottery_Prod.’||TO_VARCHAR(DATEADD(DAY, 0, CURRENT_DATE()), ‘YYYYMMDD’)||‘.*’
{%- endcall -%}

{% set pattern = load_result('my_statement')['data'][0][0] %}

    with pre as (
    select distinct
        $1::varchar(16777216) as FNAME,
        $2::varchar(16777216) as LNAME,
        $3::date as DOB,
        $4::varchar(16777216) as SSN,
        $5::varchar(16777216) as STATUS,
        $6::varchar(16777216) as EMAIL,
        $9::varchar(16777216) as DL_STATE,
        $10::varchar(16777216) as DL,
        $11::varchar(16777216) as ZIP_CODE,
        $13::varchar(16777216) as GENDER,
        $14::varchar(16777216) as START_DATE,
        $14::varchar(16777216) as SUBMIT_DATETIME,
        metadata$filename::varchar(16777216) as source_filename
    from @{{ source('PROD_REPORTS_RESPONSIBLE_GAMING','VA_SELF_EXCLUSION') }} 
        (file_format => 'STBL_REPORTS.RESPONSIBLE_GAMING.va_self_exclusion',  pattern=>'{{pattern}}')
),

INBOUND_COUNT AS (
    SELECT distinct TO_DATE(TO_TIMESTAMP(START_DATE, 'MM/DD/YYYY HH:MI:SS AM')) AS START_DATE_MODIFIED
    FROM pre
    WHERE START_DATE_MODIFIED::DATE = SYSDATE()::DATE - 1 
)

SELECT COUNT(*) FROM INBOUND_COUNT

{%- endcall -%}

{% if execute %}
{% set results = load_result(‘rec_count’)[‘data’][0][0] %}
{% if results.data|length > 0 %}
select
max(ROW_START_TIME) as max_ROW_START_TIME ,
dateadd( minute, 30 ,max(ROW_START_TIME)) as max_ROW_START_TIME_plus_30_minutes
from {{ source(‘PROD_REPORTS_RESPONSIBLE_GAMING’,‘SE_AUDIT_HISTORY_T’) }}
where state = ‘VA’
having max_ROW_START_TIME_plus_30_minutes < sysdate() or max_ROW_START_TIME is null
{% endif %}
{% endif %}

Error I am getting - Invalid ‘)’ in line 7. Can you please guide