Viewing dependency information should include
identifying USER_DEPENDENCIES
identifying ALL_DEPENDENCIES
writing a select statement to see the dependency information in the dictionary views.