ORA-01473

Error: ORA-01473: cannot have subqueries in CONNECT BY clause

Causa: Subqueries cannot be used in a CONNECT BY clause.

Acción: Remove the subquery or move it to the WHERE clause.