DBA Data[Home] [Help]

VIEW: APPS.PAY_US_EMP_FED_TAX_RULES_1_DFV

Source

View Text - Preformatted

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
View Text - HTML Formatted

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