Once the payroll is run the two important tables which get updated are:
1. PAY_RUN_RESULTS - Holds the run results fromprocessing of each element entry for assignments
2. PAY_RUN_RESULT_VALUES - This table holds the actual run result values that are calculated from processing the element entry in payroll run.
For more details on the tables, please go through this URL - http://www.slideshare.net/aboutoracleapps/oracle-hrms-payroll-table-overview
Slide no 19 list the query to fetch the run result information.