PLS-01708 – Oracle Error Code

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