PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

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..)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center