SQL Rewriting

Hi - is there a better way of rewriting this query ,Please help!

SQL MONITOR REPORT has been attached, actually it took more than 1.5 report as against the report, but what I'm looking here is how to rewrite the query.

delete from ps_proj_resource a   

WHERE business_unit = 'UGBL'

and ACCOUNTING_DT = '11-JUN-15'

and  analysis_type <> 'BLD'

and (resource_id_from) in (

        select  business_unit, project_id, resource_id_from from ps_proj_resource a   

            WHERE business_unit = 'UGBL'

            and ACCOUNTING_DT = '11-JUN-15'

            and EXISTS

          (SELECT 'x'

             FROM sysfs.DEL_PS_Q_LIMS_MNTH_TMP