Employee details query in Fusion/Cloud

 SELECT
pu.username,
ppnf.first_name,
ppnf.last_name,
ppnf.display_name,
ppnf.effective_start_date,
ppnf.effective_end_date,
papf.person_number,
pea.email_address
FROM 
  per_all_people_f papf
, per_person_names_f ppnf
, per_users pu
, per_email_addresses pea
WHERE 1=1
and ppnf.person_id(+) = papf.person_id
and ppnf.name_type(+) = 'GLOBAL'
and pea.email_address_id(+) = papf.primary_email_id
and papf.person_id = pu.person_id(+)
and pu.active_flag(+) = 'Y'
and sysdate between nvl(papf.effective_start_date, sysdate) and nvl(papf.effective_end_date, sysdate)
and sysdate between nvl(pea.date_from(+), sysdate) and nvl(pea.date_to(+), sysdate)
and sysdate between nvl(ppnf.effective_start_date(+), sysdate) and nvl(ppnf.effective_end_date(+), sysdate)
and sysdate between nvl(pu.start_date(+), sysdate) and nvl(pu.end_date(+), sysdate)
and sysdate between nvl(papf.effective_start_date, sysdate) and nvl(papf.effective_end_date, sysdate)