Forcing Index fast full scan - 19c

Hi Team,

SELECT /*+ GATHER_PLAN_STATISTICS */ HDR.EMBOOK_HEADER_ID,
APRV.MAX_APRV_REQUEST_ID MAX1_APRV, SUB.MAX_SUB_REQUEST_ID MAX2_SUB
FROM XX_APEX.XXTTD_APEX_EMBOOK_HDR_TAB HDR LEFT JOIN ( SELECT
BILL_HEADER_ID, MAX(REQUEST_ID) AS MAX_APRV_REQUEST_ID FROM
XX_APEX.XXTTD_AP_EMBOOK_APRVL_TRNS_TAB WHERE PROCESS_ID = 20 GROUP BY
BILL_HEADER_ID ) APRV ON APRV.BILL_HEADER_ID = HDR.EMBOOK_HEADER_ID
LEFT JOIN ( SELECT EMBOOK_HEADER_ID, MAX(REQUEST_ID) AS
MAX_SUB_REQUEST_ID FROM XX_APEX.XXTTD_APEX_EMBOOK_SUBLINES_TAB GROUP BY
EMBOOK_HEADER_ID ) SUB ON SUB.EMBOOK_HEADER_ID = HDR.EMBOOK_HEADER_ID