postgresql- not exist

전용페이 2차인증 없는 데이터 전용 페이 결제수단 계좌의 출금동의만료일자 수정
UPDATE SPPDB.TB XCLV PAY ACCT
SET WTDR AGRE EXPR YMD = CURRENT DATE + '14 DAYS': : INTERVAL
WHERE XCLY PAY BILLREY IN (
SELECT XPPC.XCLV PAY BILLKEY
FROM
SFFDB. TB XCLV PAY PYMT COM XPPC
INNER JOIN SPPDB. TB XCLV PAY ACCT XPA ON XPPC. XCLV PAY BILLREY = XPA.XULV PAY BILLKEY
INNER JOIN SPPDB.TB XCLV PAY USER XPU ON XPU.XCLV PAY USER NO = XPPC.XCLV FAY USER NO
WHERE NOT EXISTS (
SELECT 1
FROM SPPDB. TB XCLV PAY SCND AUTHTI HIS HIS
WHERE HIS.XCLV PAY BILLKEY=
XPPC.XCLV PAY BILLREY
)
AND XPPC.RELS YMD IS NULL
)  --IN