[Home] [Help]
VIEW: APPS.PAY_US_ASG_SCHOOLS_V
Source
View Text - Preformatted
SELECT DISTINCT PUR.ASSIGNMENT_ID , PUR.JURISDICTION_CODE , PUR.TAX_UNIT_ID FROM PAY_US_ASG_REPORTING PUR WHERE LENGTH(PUR.JURISDICTION_CODE) = 8
View Text - HTML Formatted
SELECT DISTINCT PUR.ASSIGNMENT_ID
, PUR.JURISDICTION_CODE
, PUR.TAX_UNIT_ID
FROM PAY_US_ASG_REPORTING PUR
WHERE LENGTH(PUR.JURISDICTION_CODE) = 8