Query to find TOWN_OF_BIRTH,REGION_OF_BIRTH,COUNTRY_OF_BIRTH,PERSON_NUMBER,DATE_OF_DEATH,BLOOD_TYPE,DATE_OF_BIRTH OF EMPLOYEE of Employee - Oracle Fusion HCM

Fusion Queries

Employee Details in Fusion HCM

Oracle Fusion HCM : 

TOWN_OF_BIRTH,

REGION_OF_BIRTH,

COUNTRY_OF_BIRTH,

PERSON_NUMBER,

DATE_OF_DEATH,

BLOOD_TYPE,

DATE_OF_BIRTH  

SELECT 

papf.person_number,          

pp.blood_type,          

pp.date_of_birth dob,          

pp.date_of_death,          

pp.country_of_birth,          

pp.region_of_birth,          

pp.town_of_birth  

   

FROM 

per_all_people_f papf, 

per_persons 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