SQL Query to Identify Work Email Addresses Flagged as Primary in Oracle HCM

SELECT 
    pea.email_address_id,
    papf.person_id,
    pea.email_type,
    pea.email_address,
    CASE 
        WHEN pea.email_address_id = papf.primary_email_id THEN 'Y'
        ELSE 'N'
    END AS primary_email_flag
FROM 
    per_email_addresses pea,
    per_all_people_f papf
WHERE 
    pea.person_id = papf.person_id
    AND TRUNC(SYSDATE) BETWEEN papf.effective_start_date AND papf.effective_end_date;

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.