Purge checklist tasks are missing in the report

Summary: we are building a report to fetch purge and archived checklist tasks . We ran the purge process for the onboarding checklist report is only fetching the checklist name and tasks are blank.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

SELECT distinct pcaa.ALLOCATED_CHECKLIST_ID,
PAPF.PERSON_NUMBER,
PPNF.DISPLAY_NAME AS "Full Name",
PCT.NAME AS CHECKLIST_NAME,
(select PCATL.TASK_NAME
from PER_CHK_ARCH_ALLOC_TASKS_TL pcatl
where
PCATL.ALLOCATED_TASK_ID = PCAT.ALLOCATED_TASK_ID
and ROWNUM = 1
) as TASK_NAME,
PCAA.CHECKLIST_CATEGORY,
--PCAA.CHECKLIST_INSTANCE,