Oracle Message ORA-02251 - subquery not allowed here

ERRORsubquery not allowed here
CAUSESubquery is not allowed here in the statement.
ACTIONRemove the subquery from the statement.