SELECT ROWID, STA_INFORMATION_CATEGORY, STA_INFORMATION2, STA_INFORMATION3, STA_INFORMATION1,
STA_INFORMATION2 || '.' || (DECODE (STA_INFORMATION_CATEGORY,
'AK', STA_INFORMATION_CATEGORY,
'AL', STA_INFORMATION_CATEGORY,
'AR', STA_INFORMATION_CATEGORY,
'AZ', STA_INFORMATION_CATEGORY || '.' || STA_INFORMATION3,
'CA', STA_INFORMATION_CATEGORY,
'CO', STA_INFORMATION_CATEGORY,
'CT', STA_INFORMATION_CATEGORY,
'DC', STA_INFORMATION_CATEGORY,
'DE', STA_INFORMATION_CATEGORY,
'FL', STA_INFORMATION_CATEGORY,
'GA', STA_INFORMATION_CATEGORY,
'HI', STA_INFORMATION_CATEGORY,
'IA', STA_INFORMATION_CATEGORY,
'ID', STA_INFORMATION_CATEGORY,
'IL', STA_INFORMATION_CATEGORY,
'IN', STA_INFORMATION_CATEGORY || '.' || STA_INFORMATION1,
'KS', STA_INFORMATION_CATEGORY,
'KY', STA_INFORMATION_CATEGORY,
'LA', STA_INFORMATION_CATEGORY,
'MA', STA_INFORMATION_CATEGORY,
'MD', STA_INFORMATION_CATEGORY,
'ME', STA_INFORMATION_CATEGORY,
'MI', STA_INFORMATION_CATEGORY,
'MN', STA_INFORMATION_CATEGORY,
'MO', STA_INFORMATION_CATEGORY,
'MS', STA_INFORMATION_CATEGORY,
'MT', STA_INFORMATION_CATEGORY,
'NC', STA_INFORMATION_CATEGORY,
'ND', STA_INFORMATION_CATEGORY,
'NE', STA_INFORMATION_CATEGORY,
'NH', STA_INFORMATION_CATEGORY,
'NJ', STA_INFORMATION_CATEGORY,
'NM', STA_INFORMATION_CATEGORY,
'NV', STA_INFORMATION_CATEGORY,
'NY', STA_INFORMATION_CATEGORY,
'OH', STA_INFORMATION_CATEGORY,
'OK', STA_INFORMATION_CATEGORY,
'OR', STA_INFORMATION_CATEGORY,
'PA', STA_INFORMATION_CATEGORY,
'RI', STA_INFORMATION_CATEGORY,
'SC', STA_INFORMATION_CATEGORY,
'SD', STA_INFORMATION_CATEGORY,
'TN', STA_INFORMATION_CATEGORY,
'TX', STA_INFORMATION_CATEGORY,
'UT', STA_INFORMATION_CATEGORY,
'VA', STA_INFORMATION_CATEGORY,
'VT', STA_INFORMATION_CATEGORY,
'WA', STA_INFORMATION_CATEGORY,
'WI', STA_INFORMATION_CATEGORY,
'WV', STA_INFORMATION_CATEGORY, (DECODE (STA_INFORMATION_CATEGORY,
'WY', STA_INFORMATION_CATEGORY, NULL)), NULL))
FROM PAY_US_EMP_STATE_TAX_RULES_F
SELECT ROWID
, STA_INFORMATION_CATEGORY
, STA_INFORMATION2
, STA_INFORMATION3
, STA_INFORMATION1
,
STA_INFORMATION2 || '.' || (DECODE (STA_INFORMATION_CATEGORY
,
'AK'
, STA_INFORMATION_CATEGORY
,
'AL'
, STA_INFORMATION_CATEGORY
,
'AR'
, STA_INFORMATION_CATEGORY
,
'AZ'
, STA_INFORMATION_CATEGORY || '.' || STA_INFORMATION3
,
'CA'
, STA_INFORMATION_CATEGORY
,
'CO'
, STA_INFORMATION_CATEGORY
,
'CT'
, STA_INFORMATION_CATEGORY
,
'DC'
, STA_INFORMATION_CATEGORY
,
'DE'
, STA_INFORMATION_CATEGORY
,
'FL'
, STA_INFORMATION_CATEGORY
,
'GA'
, STA_INFORMATION_CATEGORY
,
'HI'
, STA_INFORMATION_CATEGORY
,
'IA'
, STA_INFORMATION_CATEGORY
,
'ID'
, STA_INFORMATION_CATEGORY
,
'IL'
, STA_INFORMATION_CATEGORY
,
'IN'
, STA_INFORMATION_CATEGORY || '.' || STA_INFORMATION1
,
'KS'
, STA_INFORMATION_CATEGORY
,
'KY'
, STA_INFORMATION_CATEGORY
,
'LA'
, STA_INFORMATION_CATEGORY
,
'MA'
, STA_INFORMATION_CATEGORY
,
'MD'
, STA_INFORMATION_CATEGORY
,
'ME'
, STA_INFORMATION_CATEGORY
,
'MI'
, STA_INFORMATION_CATEGORY
,
'MN'
, STA_INFORMATION_CATEGORY
,
'MO'
, STA_INFORMATION_CATEGORY
,
'MS'
, STA_INFORMATION_CATEGORY
,
'MT'
, STA_INFORMATION_CATEGORY
,
'NC'
, STA_INFORMATION_CATEGORY
,
'ND'
, STA_INFORMATION_CATEGORY
,
'NE'
, STA_INFORMATION_CATEGORY
,
'NH'
, STA_INFORMATION_CATEGORY
,
'NJ'
, STA_INFORMATION_CATEGORY
,
'NM'
, STA_INFORMATION_CATEGORY
,
'NV'
, STA_INFORMATION_CATEGORY
,
'NY'
, STA_INFORMATION_CATEGORY
,
'OH'
, STA_INFORMATION_CATEGORY
,
'OK'
, STA_INFORMATION_CATEGORY
,
'OR'
, STA_INFORMATION_CATEGORY
,
'PA'
, STA_INFORMATION_CATEGORY
,
'RI'
, STA_INFORMATION_CATEGORY
,
'SC'
, STA_INFORMATION_CATEGORY
,
'SD'
, STA_INFORMATION_CATEGORY
,
'TN'
, STA_INFORMATION_CATEGORY
,
'TX'
, STA_INFORMATION_CATEGORY
,
'UT'
, STA_INFORMATION_CATEGORY
,
'VA'
, STA_INFORMATION_CATEGORY
,
'VT'
, STA_INFORMATION_CATEGORY
,
'WA'
, STA_INFORMATION_CATEGORY
,
'WI'
, STA_INFORMATION_CATEGORY
,
'WV'
, STA_INFORMATION_CATEGORY
, (DECODE (STA_INFORMATION_CATEGORY
,
'WY'
, STA_INFORMATION_CATEGORY
, NULL))
, NULL))
FROM PAY_US_EMP_STATE_TAX_RULES_F
|
|
|