select papf.person_number, papf.primary_email_id,pea.email_address_id,EMAIL_TYPE,DATE_FROM,DATE_TO,EMAIL_ADDRESS
from
per_all_people_f papf, PER_EMAIL_ADDRESSES pea
where papf.person_id=pea.person_id
and papf.primary_email_id=pea.email_address_id
and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date
No comments:
Post a Comment