Emails Not Bursting Despite Successful Job Completion

Summary:

We have a bursting notification configured for contingent worker end date alerts. Although the job completes successfully, no emails are being sent.

Additionally, the job history does not show any notification details.

Could someone please assist?

WITH
org_hierarchy AS (SELECT
pdtn.pk1_start_value AS organization_id,
level AS lvl,
CONNECT_BY_ROOT pdtn.pk1_start_value AS root
FROM
per_dept_tree_node pdtn
WHERE
pdtn.tree_code = 'EE_DEPT_TREE'
CONNECT BY
PRIOR pdtn.pk1_start_value = pdtn.parent_pk1_value),
hrbp_email_by_org AS (SELECT DISTINCT
oh.organization_id,
CASE
WHEN par.include_top_hier_node = 'N' AND lvl = 1