Query including earnings accounts + GL accounts #'s
I’m building a query, that should contain employee data together with deductions, taxes, earnings and GL account #’s. No problem by doing that for deductions and taxes thanks to tabs PAY_NA_DED_LIAB and PY_NA_TAX_LIAB, but I can’t find any similar tab for earnings. I’ve tried to search for any tab including earnings codes + account #’s in TOAD, without success. Would someone please advise me?
(I can do some kind of temporary solution by setting up a condition, that this and that earnings code is going to this GL account, but that’s not a correct database & SQL solution..)