Query to find Email details of an Employee

Fusion Queries

Employee Details in Fusion HCM

Query to find Email details of an Employee

Oracle Fusion HCM : 

PERSON_NUMBER, 

EMAIL_TYPE, 

EMAIL_ADDRESS 

 SELECT 

 

 papf.person_number, 

 pea.email_type, 

 pea.email_address     

 

 FROM per_all_people_f papf, 

 per_email_addresses pea    

 

 WHERE 

 

 papf.person_id = pea.person_id(+) -- (+)to fetch if some data is not present in system      

 AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date                                  

 AND papf.effective_end_date 

 ORDER BY person_number