ops$tkyte%ORA9IR2> desc user_dependencies
 Name                                     Null?    Type
 ---------------------------------------- -------- ----------------------------
 NAME                                     NOT NULL VARCHAR2(30)
 TYPE                                              VARCHAR2(17)
 REFERENCED_OWNER                                  VARCHAR2(30)
 REFERENCED_NAME                                   VARCHAR2(64)
 REFERENCED_TYPE                                   VARCHAR2(17)
 REFERENCED_LINK_NAME                              VARCHAR2(128)
 SCHEMAID                                          NUMBER
 DEPENDENCY_TYPE                                   VARCHAR2(4)



name+type

referenced_owner+referenced_name+referenced_type


those are two of the keys, you are connecting by -name, insufficient. 

ops$tkyte%ORA10GR2> select name,type,referenced_name,referenced_type
  2  from  user_dependencies
  3  connect by prior trim(name) = trim(referenced_name) and
  4              prior trim(type) = trim(referenced_type)
  5                          start  with referenced_name = 'T';

NAME       TYPE       REFERENCED_NAME           REFERENCED_TYPE
---------- ---------- ------------------------- -------------------------
PT1        PROCEDURE  T                         TABLE
PT2        PROCEDURE  PT1                       PROCEDURE
PT3        PROCEDURE  PT2                       PROCEDURE

ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2> create table t_user_dependencies as select * from user_dependencies;

Table created.

ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2> select name,type,referenced_name,referenced_type
  2  from  t_user_dependencies
  3  connect by prior trim(name) = trim(referenced_name) and
  4              prior trim(type) = trim(referenced_type)
  5                          start  with referenced_name = 'T';

NAME       TYPE       REFERENCED_NAME           REFERENCED_TYPE
---------- ---------- ------------------------- -------------------------
PT1        PROCEDURE  T                         TABLE
PT2        PROCEDURE  PT1                       PROCEDURE
PT3        PROCEDURE  PT2                       PROCEDURE

ops$tkyte%ORA10GR2> create table t ( x int );

Table created.

ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2> create database link ora10gr2@loopback connect to ops$tkyte identified by foobar using 'ora10gr2';

Database link created.

ops$tkyte%ORA10GR2> select * from dual@ora10gr2@loopback;

D
-
X

ops$tkyte%ORA10GR2> create or replace procedure p
  2  as
  3  begin
  4          for x in ( select * from t@ora10gr2@loopback )
  5          loop
  6                  dbms_output.put_line( x.x );
  7          end loop;
  8  end;
  9  /

Procedure created.

ops$tkyte%ORA10GR2> select * from user_dependencies where name = 'P' and referenced_link_name is not null;

NAME                           TYPE              REFERENCED_OWNER
------------------------------ ----------------- ------------------------------
REFERENCED_NAME
----------------------------------------------------------------
REFERENCED_TYPE
-----------------
REFERENCED_LINK_NAME
-------------------------------------------------------------------------------
  SCHEMAID DEPE
---------- ----
P                              PROCEDURE         OPS$TKYTE
T
TABLE
ORA10GR2.COM@LOOPBACK
       592 HARD

ops$tkyte%ORA11GR2> select distinct dependency_type from dba_dependencies;

DEPE
----
HARD
REF

ops$tkyte%ORA10GR2> create function f( x in number ) return varchar2
  2  deterministic
  3  as
  4  begin
  5          return to_char(x,'999999999');
  6  end;
  7  /

Function created.

ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2> create table t ( x number );

Table created.

ops$tkyte%ORA10GR2> create index t_idx on t(f(x));

Index created.

ops$tkyte%ORA10GR2> create trigger t
  2  before insert on t
  3  begin
  4          null;
  5  end;
  6  /

Trigger created.

ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2> select name, type, referenced_name, referenced_type, dependency_type
  2    from user_dependencies
  3  /

NAME  TYPE       REFERENCED REFERENCED DEPE
----- ---------- ---------- ---------- ----
F     FUNCTION   STANDARD   PACKAGE    HARD
T_IDX INDEX      F          FUNCTION   REF
T     TRIGGER    T          TABLE      HARD

ops$tkyte%ORA11GR2> create table t ( nm varchar2(10), gender varchar2(1) );

Table created.

ops$tkyte%ORA11GR2> 
ops$tkyte%ORA11GR2> insert into t values ( 'Arun','M' );

1 row created.

ops$tkyte%ORA11GR2> insert into t values ( 'Anitha','F' );

1 row created.

ops$tkyte%ORA11GR2> insert into t values ( 'Bala','M' );

1 row created.

ops$tkyte%ORA11GR2> insert into t values ( 'Banu','F' );

1 row created.

ops$tkyte%ORA11GR2> insert into t values ( 'Tom','M' );

1 row created.

ops$tkyte%ORA11GR2> 
ops$tkyte%ORA11GR2> with
  2  male as (select nm, row_number() over (order by nm) rn from t where gender = 'M'),
  3  female as (select nm, row_number() over (order by nm) rn from t where gender = 'F')
  4  select male.nm, female.nm
  5    from male full outer join female on (male.rn = female.rn)
  6   order by coalesce( male.rn, female.rn)
  7  /

NM         NM
---------- ----------
Arun       Anitha
Bala       Banu
Tom

select rpad('*',2*level,'*')||referenced_owner||'.'||referenced_name||'.'||referenced_type nm, name, type
  from user_dependencies
 start with referenced_name = 'PKG_A' and referenced_type = 'PACKAGE' and referenced_owner = user
connect by prior referenced_owner = user and referenced_name = prior name and referenced_type = prior type
/

EXCEPTION 
WHEN OTHERS THEN 
ROLLBACK;