Query to get dependencies on an object till n level

Query to get dependencies on an object till n level
=============================================
SELECT DISTINCT a.referenced_name main_parent, a.NAME main_child,
b.referenced_name next_level_parent, b.NAME next_level_child
FROM all_dependencies a, all_dependencies b
WHERE 1 = 1
AND b.referenced_name = a.NAME
AND a.referenced_name IN
('YYY_CIB_FLAGS_AGV',
'YYY_CIB_AGV',
'YYY_SLA_HOURS_AGV',
'YYY_SPL_PARTS_AGV'
)
ORDER BY 1, 3
==============================================