Employee Absence records not deleted for canceled work relationship

Some employee records with canceled work relationships still show associated absence entries. When I search using this query, I can still find those absence records. How can I delete them?

 

SELECT PEOPLE.PERSON_ID FROM fusion.ANC_PER_ABS_ENTRIES A , fusion.ANC_ABSENCE_TYPES_F_TL TYP, fusion.PER_ALL_PEOPLE_F PEOPLE WHERE ( A.START_DATETIME BETWEEN TYP.EFFECTIVE_START_DATE AND NVL(TYP.EFFECTIVE_END_DATE,TO_DATE('31/12/4712','DD/MM/YYYY')) ) AND PEOPLE.PERSON_ID=A.PERSON_ID AND A.START_DATE BETWEEN PEOPLE.EFFECTIVE_START_DATE AND NVL(PEOPLE.EFFECTIVE_END_DATE,TO_DATE('31/12/4712','DD/MM/YYYY')) AND TYP.ABSENCE_TYPE_ID = A.ABSENCE_TYPE_ID AND TYP.LANGUAGE ='US' AND A.PERIOD_OF_SERVICE_ID IS NOT NULL AND NOT EXISTS ( SELECT 1 FROM fusion.PER_PERIODS_OF_SERVICE T2 WHERE A.PERIOD_OF_SERVICE_ID=T2.PERIOD_OF_SERVICE_ID AND A.PERSON_ID =T2.PERSON_ID )