Oracle Fusion HCM :Absence Management Qualification Plans table name

ANC_PER_ABS_PLAN_ENTRIES

ANC_PER_ABS_PLN_SUMM_ENT

ANC_PER_ABS_ENTRIES--normal absence entry details (this is the parent record):


Query:
/
SELECT DISTINCT papf.person_number "PersonNumber",
                aaptl.name absence_plan_name,
                appe.enrt_st_dt,
                appe.enrt_end_dt,
                appe.status,
                appe.per_plan_enrt_id,
                appe.wait_period_dur_uom,
                appe.wait_period_dur_units,
                appe.recipient_alias,
                papf.effective_start_date,
                papf.effective_end_date
  FROM anc_absence_plans_f_tl aaptl, anc_per_plan_enrollment appe --,ANC_PER_ACRL_ENTRY_DTLS APAED
                                                                 , per_all_people_f papf
 --,ANC_PER_ABS_ENTRIES APAE

 WHERE     1 = 1
       AND appe.enrt_st_dt BETWEEN papf.effective_start_date AND SYSDATE
       AND appe.plan_id = aaptl.absence_plan_id
       AND appe.person_id = papf.person_id
       AND appe.enrt_st_dt BETWEEN papf.effective_start_date
                               AND papf.effective_end_date