SELECT ROWID, FED_INFORMATION_CATEGORY, FED_INFORMATION1,
(DECODE (FED_INFORMATION_CATEGORY,
'Further Federal Tax Info', FED_INFORMATION_CATEGORY || '.' || FED_INFORMATION1, NULL))
FROM PAY_US_EMP_FED_TAX_RULES_F
SELECT ROWID
, FED_INFORMATION_CATEGORY
, FED_INFORMATION1
,
(DECODE (FED_INFORMATION_CATEGORY
,
'FURTHER FEDERAL TAX INFO'
, FED_INFORMATION_CATEGORY || '.' || FED_INFORMATION1
, NULL))
FROM PAY_US_EMP_FED_TAX_RULES_F
|
|
|