Oracle Fusion HCM:Absence Management Query

SELECT aapf.absence_plan_id, aapft.NAME

  FROM anc_absence_plans_f_tl aapft, anc_absence_plans_f aapf

 WHERE aapft.absence_plan_id = aapf.absence_plan_id

       AND aapf.plan_status = 'A'   -- added to pick only Active Absence Plans

       AND TRUNC (SYSDATE) BETWEEN aapf.effective_start_date

                               AND aapf.effective_end_date

       AND TRUNC (SYSDATE) BETWEEN aapft.effective_start_date

                               AND aapft.effective_end_date

       AND aapft.language = 'US'