VIEW: APPS.PAY_US_ASG_STATES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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