Another user's package bodies will only be visible if you have select privileges on the sys.dba_objects and sys.dba_source views. The "Use DBA views if available" preference (Tools > Preferences > Options tab page) also needs to be enabled to make use of these views. To debug another user's package bodies you additionally need the "create any procedure" system privilege.
