Worker Visa V2 Expiration Alert is still sending a notice if Visa Permit Status is marked "Inactive"

Hi,

I have used the below but the visa expiration notification is still being sent to the employee even though the Visa Status is marked Inactive in Person Management under Documents.

Please see the SQL query.

Any help would be greatly appreciated.

EXISTS ( SELECT 'X' FROM PER_VISAS_PERMITS_F WHERE PERSON_ID = ${PersonId} AND VISA_PERMIT_STATUS = 'A' AND EXPIRATION_DATE >= SYSDATE AND EXPIRATION_DATE <= SYSDATE + 30)