Fusion Query

Fusion Queries Employee Details in Fusion HCM Query to find Address Details of Employee - Oracle Fusion HCM Oracle Fusion HCM :  PERSON_NUMBER,           ADDRESS_TYPE,           ADDRESS_LINE_1,           ADDRESS_LINE_2,           ADDRESS_LINE_3,           ADDRESS_LINE_4,           BUILDING,           FLOOR_NUMBER,           TOWN_OR_CITY,           REGION_1,           REGION_2,           REGION_3,   COUNTRY,           POSTAL_CODE    SELECT  person_number,           ppauf.address_type,           paf.address_line_1,         ...

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, D ATE_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