You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Work Tax Jurisdiction Details Query - Location

in Payroll and Global Payroll Interface (GPI)

Summary:

We are currently working on retrieving Work Tax Jurisdiction information that gets populated at the Location level after running Address Validation in Final Mode.

Here is the scenario we are dealing with:

After executing the Address Validation process in Final Mode for a Location, the Work Tax Jurisdictions are being reflected on the Location screen. We now need to fetch these jurisdiction details — specifically the ones assigned at the Location level — via a SQL query against the Oracle HCM database tables.

Could anyone help us with the appropriate query or point us to the correct base tables/views that store this information? We are looking to retrieve:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!