The query at the top is missing PRIOR before referenced name & you may need to add NOCYCLE if there are dependency loops:
select lpad(' ',(level-1)*2)||name||'('|| type || ')' from dba_dependencies
where level <2
connect by nocycle prior referenced_owner=owner
and prior referenced_name=name
start with name = 'OBJECT_NAME'
This will give you all the things OBJECT_NAME depends on.
Note this only lists static dependencies. If you have dynamic SQL or PL/SQL, objects these reference are not shown by the dependencies views.