select
distinct doc_type.document_type,
papf.person_number,
hddp.online_enabled,
hddp.paper_enabled,
hddp.email_enabled
from
HR_DOCUMENT_DELIVERY_hddpS hddp,
HR_DOCUMENT_TYPES_TL doc_type,
per_all_people_f papf
where
hddp.document_type_id = doc_type.document_type_id
and papf.person_id = hddp.person_id
and doc_type.language = 'US'
and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date
Related Posts
Hire an Employee in Oracle Fusion
Posted on