FND Design Data [Home] [Help]

View: PAY_US_TAX_UNIT_STATES_V

Product: PAY - Payroll
Description: - Retrofitted - Retrofitted
Implementation/DBA Data: ViewAPPS.PAY_US_TAX_UNIT_STATES_V
View Text

SELECT DISTINCT SUBSTR(JURISDICTION_CODE
, 1
, 2)||'-000-0000' STATE_CODE
, TAX_UNIT_ID
FROM PAY_US_ASG_REPORTING

Columns

Name
STATE_CODE
TAX_UNIT_ID