sql query to get pending to do enrollments

Summary:

I need help ina sql query to get pending "To do"/"Required" enrollments details for the person so that i can send them alerts in Teams. Below is the query. It works for some employees. For some employees it is not showing data even if it is showing in front end.

Content (please ensure you mask any confidential information):

WITH

event_data AS (
SELECT
a.event_id AS root_event_id,
e.learning_item_id AS root_learning_item_id,
u.person_id AS learner_id,
DECODE(
a.completion_status,
'C','Completed','P','Passed','I','Incomplete','F','Failed','U','Unknown','N','Not Attempted',