Custom resource alert created using alert composer not working properly

Summary: Custom resource alert created using alert composer not working properly

Content (please ensure you mask any confidential information):

Below is the filter added:

EXISTS (SELECT 'x' FROM PER_ALL_ASSIGNMENTS_M T1,PER_PERIODS_OF_SERVICE T2 WHERE T1.PERIOD_OF_SERVICE_ID = T2.PERIOD_OF_SERVICE_ID AND T1.Assignment_Type ='E' AND TRUNC(T1.PROJECTED_ASSIGNMENT_END)>=TRUNC(SYSDATE) AND T1.assignment_status_type = 'ACTIVE' AND sysdate BETWEEN T1.effective_start_date AND T1.effective_end_date AND T2.person_id = ${PersonId} )

Even I have added specifically

Assignment_Type ='E' & assignment_status_type = 'ACTIVE' in the filter then also