PeopleSoft stores all of its information/code in database tables. Each of the definitions that you can open in Application Designer can be found in one or more tables in the database. Knowing these tables can be helpful:
SQL Definitions
Object Type (11/15/2006)
Work in Progress…