Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!
Oracle R12 12.2.10 - Query Earnings Policy - what table(s)?
I need to bring the earnings policy information into a query. This data is selected/entered in the Additional Assignment Information area of the Assignment Time Information form.
HXT_ADD_ASSIGN_INFO_X includes an Earning Policy field (looks like an ID reference like 82) for all applicable employees.
HXTFV_ADD_ASSIGN_INFO includes an Earning Policy field (description info 7.5 Hour Day) for almost all employees. This table does not report for all.
Is there a table that converts the ID from HXT_ADD_ASSIGN_INFO_X to the description? The form entry does have a LOV but I cannot find where that is stored.