Need guidance for sql tuning

Hi Team,

Can you please guide if we can increase the performance of below select query. We are using 19.28 database version.

SQL Text      : SELECT EMBOOK_HEADER_ID, MAX1_APRV, MAX2_SUB FROM (SELECT

                NVL(HDR.DR_CR_NO,HDR.FILE_NUMBER) AS DR_CR_NO,

                HDR.EMBOOK_HEADER_ID, MAX(APT.REQUEST_ID) MAX1_APRV,

                MAX(SUB.REQUEST_ID) MAX2_SUB FROM XXTTD_APEX_EMBOOK_HDR_TAB

                HDR, XX_APEX.XXTTD_APEX_EMBOOK_SUBLINES_TAB SUB,

                XX_APEX.XXTTD_AP_EMBOOK_APRVL_TRNS_TAB APT WHERE

                HDR.EMBOOK_HEADER_ID=SUB.EMBOOK_HEADER_ID AND

                SUB.EMBOOK_HEADER_ID=APT.BILL_HEADER_ID AND