pls-01708 error code

In searched DELETE- UPDATE or INSERT- table must not appear in FROM clause of subqueries in search condition