Help required in re writing the query

Hi All,

Can this query be re written in anyother efficient ways? it takes about 30mins to execute attaching the sql monitor report.

Version is 11203 and o.s is linux

UPDATE TMP54 TMP5
SET     CURRENCY_PLST_FLG     = 'E'
WHERE   PROCESS_INSTANCE      = 1119264
        AND ANALYSIS_TYPE     = 'RAL'
        AND CURRENCY_PLST_FLG = 'R'
        AND EXISTS
        (
                SELECT 'X'
                FROM    PS_PROJ_RESOURCE PR
                WHERE   PR.BUSINESS_UNIT   = TMP5.BUSINESS_UNIT
                        AND PR.PROJECT_ID  = TMP5.PROJECT_ID
                        AND PR.ACTIVITY_ID = TMP5.ACTIVITY_ID
                        AND
                        (
                                PR.RESOURCE_ID_FROM = TMP5.RESOURCE_ID
                                OR PR.RESOURCE_ID   = TMP5.RESOURCE_ID_FROM
                        )
                        AND PR.FOREIGN_AMOUNT = -1*TMP5.FOREIGN_AMOUNT