VIEW: APPS.PAY_CA_EMP_FED_TAX_INFO_F_DFV

Source

View Text - Preformatted

SELECT ROWID, CA_TAX_INFORMATION_CATEGORY, (DECODE (CA_TAX_INFORMATION_CATEGORY, 'Year End and Other Info', CA_TAX_INFORMATION1, 'QC', CA_TAX_INFORMATION1, 'PROV', CA_TAX_INFORMATION1, 'FED', CA_TAX_INFORMATION1, NULL)), CA_TAX_INFORMATION2,  
 (DECODE (CA_TAX_INFORMATION_CATEGORY,  
      'FED', CA_TAX_INFORMATION_CATEGORY || '.' || CA_TAX_INFORMATION1,  
      'PROV', CA_TAX_INFORMATION_CATEGORY || '.' || CA_TAX_INFORMATION1 || '.' || CA_TAX_INFORMATION2,  
      'QC', CA_TAX_INFORMATION_CATEGORY || '.' || CA_TAX_INFORMATION1,  
      'Year End and Other Info', CA_TAX_INFORMATION_CATEGORY || '.' || CA_TAX_INFORMATION1, NULL)) 
 FROM PAY_CA_EMP_FED_TAX_INFO_F

View Text - HTML Formatted

SELECT ROWID
, CA_TAX_INFORMATION_CATEGORY
, (DECODE (CA_TAX_INFORMATION_CATEGORY
, 'YEAR END
AND OTHER INFO'
, CA_TAX_INFORMATION1
, 'QC'
, CA_TAX_INFORMATION1
, 'PROV'
, CA_TAX_INFORMATION1
, 'FED'
, CA_TAX_INFORMATION1
, NULL))
, CA_TAX_INFORMATION2
, (DECODE (CA_TAX_INFORMATION_CATEGORY
, 'FED'
, CA_TAX_INFORMATION_CATEGORY || '.' || CA_TAX_INFORMATION1
, 'PROV'
, CA_TAX_INFORMATION_CATEGORY || '.' || CA_TAX_INFORMATION1 || '.' || CA_TAX_INFORMATION2
, 'QC'
, CA_TAX_INFORMATION_CATEGORY || '.' || CA_TAX_INFORMATION1
, 'YEAR END
AND OTHER INFO'
, CA_TAX_INFORMATION_CATEGORY || '.' || CA_TAX_INFORMATION1
, NULL))
FROM PAY_CA_EMP_FED_TAX_INFO_F