Status of the Absence history of an employee (SQL)

Good day,

I have the below script for which I want to also pick the status of the absence record of the employee (Approved, Pending, Rejected).

So my question is which table should I join to be able to pick the status of the absence entry.

#OracleEBS

#HRMS

#APPS12.2.5

SELECT 

 A.EMPLOYEE_NUMBER      StaffNumber,

 a.PERSON_ID,

 A.FULL_NAME         StaffName,

 o.name            Department,

 Y.NAME            AbsenceName,

 Y.ABSENCE_ATTENDANCE_TYPE_ID AbsenceId,

 X.DATE_NOTIFICATION     NotifyDate,

 X.CREATION_DATE       CreatedDate,

 X.DATE_START         LeaveStart,

 X.DATE_END          LeaveEnd,

 X.ABSENCE_DAYS        TotalDays

 FROM PER_ABSENCE_ATTENDANCES   X,

    PER_ABSENCE_ATTENDANCE_TYPES Y,