Query to find PERSON_NUMBER, PHONE_TYPE, PHONE_NUMBER, AREA_CODE, SEARCH_PHONE_NUMBER, COUNTRY_CODE_NUMBER OF EMPLOYEE of Employee - Oracle Fusion HCM

Fusion Queries

Employee Details in Fusion HCM

Oracle Fusion HCM : 

PERSON_NUMBER,

PHONE_TYPE,          

PHONE_NUMBER,          

AREA_CODE,          

SEARCH_PHONE_NUMBER,          

COUNTRY_CODE_NUMBER   

SELECT 

papf.person_number,         

pp.PHONE_TYPE,          

pp.PHONE_NUMBER,          

pp.AREA_CODE,          

pp.SEARCH_PHONE_NUMBER,          

pp.COUNTRY_CODE_NUMBER     

FROM 

per_all_people_f papf, 

per_phones pp    

WHERE 

papf.person_id = pp.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