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