Need to know approval date file & table name of absence records

Summary:

Need to know approval date file & table name of absence records

attached my sql, if anyone please modify and give me the approval date of absence

Content (required):

select per.person_number,

PNAME.DISPLAY_NAME,

abs.absence_type_id "Absence Type Id",

      abs.name absence_type,

      to_char(apae.start_date,'DD-MON-YYYY','NLS_DATE_LANGUAGE = AMERICAN') start_date,

      to_char(apae.end_date,'DD-MON-YYYY','NLS_DATE_LANGUAGE = AMERICAN') end_date,

      duration "Absence Duration"

, apae.ABSENCE_STATUS_CD

, apae.APPROVAL_STATUS_CD

, apae.PROCESSING_STATUS

, apae.PAYROLL_STATUS

, to_char(apae.SUBMITTED_DATE,'DD-MON-YYYY','NLS_DATE_LANGUAGE = AMERICAN') SUBMITTED_DATE