Query to get dependencies on an object

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