Hrms Technical Queries - (Employee Leave Details from Absence Form)

***This query will return the leaves (Sick,Maternity,Paternity....)taken by the employee.

SELECT ppf.employee_number, pt.NAME, pa.date_start, pa.date_end,pt.NAME leave_type
  FROM per_all_people_f ppf,
       per_absence_attendances pa,
       per_absence_attendance_types pt
 WHERE 1 = 1
   AND SYSDATE BETWEEN ppf.effective_start_date AND ppf.effective_end_date
   AND ppf.person_id = pa.person_id
   AND pa.absence_attendance_type_id = pt.absence_attendance_type_id
   AND pt.NAME = 'Maternity Leave'