How to Calculate Payroll Reversals

Summary:

How to include payroll reversal values in calculation

Content (required):

We have BI publisher report that calculates Payroll distribution for all of our employees. It provides us payroll run details along with Fund, Org, Account costing values. We are using Pay_Costs table to calculate the payroll values but that table does not include reversals. I have also looked into pay_run_result_values table, and it shows reversals in negative value, but if I replace pay_costs table with pay_run_result_values, we are facing issues with getting Costing details, as we cannot join run_result_values table with PAY_COST_ALLOC_KEYFLEX table.