Write a query to fetch paycalc results?
We have a requirement to send the payroll calculation results through a webservice response. We have analyzed the possible ways of getting the payroll calculated results like getting the data from PAY_FILE_DETAILS table. What if the customer didn't generate payslips? if so then we cant rely on PAY_FILE_DETAILS table. So we would to find a way to get the results generated at payroll calculation step itself. In other words, we would to query the Oracle tables to pull all the data that's displayed on a payslip.
May we know is it possible to do this ?