-- Кто зависит

SELECT LPAD(' ', (LEVEL - 1) * 2, ' ') || owner || '.' || name AS "Кто зависит",

  type,

  dependency_type

FROM all_dependencies

START WITH referenced_owner = USER

  AND referenced_name = 'ИМЯ ОБЪЕКТА'

CONNECT BY PRIOR owner = referenced_owner

  AND PRIOR name = referenced_name

  AND PRIOR type = referenced_type

/

-- От кого зависит

SELECT LPAD(' ', (LEVEL - 1) * 2, ' ') || owner || '.' || referenced_name AS "От кого зависит",

       type,

       dependency_type

FROM all_dependencies

START WITH owner = USER

  AND name = 'ИМЯ ОБЪЕКТА'

CONNECT BY PRIOR referenced_owner = owner

  AND PRIOR referenced_name = name

  AND PRIOR referenced_type = type

/