Query to find Hire and Termination Details in Fusion HCM

SELECT papf.person_number,
       ppnf.full_name employee_full_name,
       paam.assignment_number,
       pps.date_start hire_date ,
       pps.actual_termination_date
FROM   per_all_people_f papf,
       per_all_assignments_m paam,
       per_person_names_f ppnf,
       per_grades pg ,
       per_periods_of_service pps
WHERE  1 = 1
AND    trunc(SYSDATE) BETWEEN papf.effective_start_date AND    papf.effective_end_date
AND    papf.person_id = ppnf.person_id
AND    trunc(SYSDATE) BETWEEN ppnf.effective_start_date AND    ppnf.effective_end_date
AND    ppnf.name_type = 'GLOBAL'
AND    papf.person_id = paam.person_id
AND    trunc(SYSDATE) BETWEEN paam.effective_start_date AND    paam.effective_end_date
AND    paam.assignment_status_type IN ( 'ACTIVE' ) -- Active Assignment
AND    paam.assignment_type        IN ( 'E' )      -- Type Employee
AND    paam.primary_flag = 'Y'                     -- primary assignment
AND    pps.period_of_service_id(+) = paam.period_of_service_id
AND    pps.period_of_service_id =
       (
              SELECT max(pps1.period_of_service_id)
              FROM   per_periods_of_service pps1
              WHERE  pps.person_id = pps1.person_id)

Click Here