Need to know approval date file & table name of absence records attached my sql, if anyone please mo

Summary:

we use oracle fusion cloud. OBI report and analytic

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

, I alredy taking the dates below, but approved dates are different for some cases

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