Query to get an Employees Leave History in Oracle APPS

 SELECT a.date_start,

         a.date_end,

         a.absence_days,

         (SELECT name

            FROM per_absence_attendance_types

           WHERE absence_attendance_type_id = a.absence_attendance_type_id

             AND business_group_id = a.business_group_id)

            leave_type

    FROM per_absence_attendances a

   WHERE person_id =

            (SELECT person_id

               FROM per_all_people_f

              WHERE employee_number = '1234567890'

                    AND employee_number IS NOT NULL)

ORDER BY date_start DESC