FND Design Data [Home] [Help]

View: PAY_US_TAX_UNIT_COUNTIES_V

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

SELECT DISTINCT SUBSTR(JURISDICTION_CODE
, 1
, 6)||'-0000' JURISDICTION_CODE
, TAX_UNIT_ID
FROM PAY_US_ASG_REPORTING

Columns

Name
JURISDICTION_CODE
TAX_UNIT_ID