Oracle Message PLS-01708 - In searched DELETE, UPDATE or INSERT, table must not appear in FROM clause of subqueries in search condition

ERRORIn searched DELETE, UPDATE or INSERT, table must not appear in FROM clause of subqueries in search condition
CAUSEIn a searched DELETE, UPDATE or INSERT statement, the table affected must not appear in a FROM clause in any of the subqueries in the search condition.
ACTIONNone