Another option, if you use Enterprise Manager, you can right click on an object and choose either "Show Dependencies" or "Show Dependents"