Startup sql performance improvement

We saw sql taking long time in the AWR report

select a.OBJECT_LABEL_ID AS OBJECT_ID, a.WF_NAME AS OBJECT_NAME,

ibs_module.MODULE_NAME AS MODULE_NAME, a.bo_type_name AS BO_NAME,

a.UPDATED_DATE AS UPDATED_DATE, a.UPDATED_BY AS UPDATED_BY,

a.WF_TEMPLATE_VERSION AS WF_TEMPLATE_VERSION,

d.OBJECT_LABEL_ID AS CURRENT_OBJECT_LABEL_ID

from WF_TEMPLATE a, IBS_MODULE, WF_TEMPLATE d

where a.WF_TEMPLATE_ID = ?

and a.BO_CLASS_TYPE_ID = IBS_MODULE.MODULE_ID

and (a.STATUS_ID = 10 or a.STATUS_ID = 25)

and d.WF_TEMPLATE_ID = a.WF_TEMPLATE_ID

and (d.STATUS_ID = 10 or d.STATUS_ID = 25)

and d.WF_TEMPLATE_VERSION in (

select max(WF_TEMPLATE_VERSION) from WF_TEMPLATE

where WF_TEMPLATE_ID = d.WF_TEMPLATE_ID

and (STATUS_ID = 10 or STATUS_ID = 25)

)

order by a.WF_TEMPLATE_VERSION
 

DBA suggest use this sql instead

SELECT a.OBJECT_LABEL_ID AS OBJECT_ID,

a.WF_NAME AS OBJECT_NAME,

ibs_module.MODULE_NAME AS MODULE_NAME,

a.bo_type_name AS BO_NAME,

a.UPDATED_DATE AS UPDATED_DATE,

a.UPDATED_BY AS UPDATED_BY,

a.WF_TEMPLATE_VERSION AS WF_TEMPLATE_VERSION,

d.OBJECT_LABEL_ID AS CURRENT_OBJECT_LABEL_ID

FROM WF_TEMPLATE a, IBS_MODULE, WF_TEMPLATE d

WHERE a.WF_TEMPLATE_ID = :1

AND a.BO_CLASS_TYPE_ID = IBS_MODULE.MODULE_ID

AND a.STATUS_ID IN (10, 25) -- changed from (a.STATUS_ID = 10 OR a.STATUS_ID = 25)

AND d.WF_TEMPLATE_ID = a.WF_TEMPLATE_ID

AND d.STATUS_ID IN (10, 25) -- changed from (d.STATUS_ID = 10 OR d.STATUS_ID = 25)

AND d.WF_TEMPLATE_VERSION IN

(SELECT MAX (WF_TEMPLATE_VERSION)

FROM WF_TEMPLATE

WHERE WF_TEMPLATE_ID = :1 --changed from d.WF_TEMPLATE_ID

AND STATUS_ID IN (10, 25) --changed from AND (STATUS_ID = 10 OR STATUS_ID = 25)

)

ORDER BY a.WF_TEMPLATE_VERSION;