VIEW: APPS.PAY_MX_LEGISLATION_INFO_F_DFV

Source

View Text - Preformatted

SELECT ROWID, LEGISLATION_INFO_TYPE, (DECODE (LEGISLATION_INFO_TYPE, 'MX Annualization Factor', LEGISLATION_INFO1, NULL)), (DECODE (LEGISLATION_INFO_TYPE, 'MX Annualization Factor', FND_NUMBER.CANONICAL_TO_NUMBER(LEGISLATION_INFO2), NULL)), (DECODE (LEGISLATION_INFO_TYPE, 'MX Minimum Wage Information', LEGISLATION_INFO1, NULL)), (DECODE (LEGISLATION_INFO_TYPE, 'MX Minimum Wage Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEGISLATION_INFO2), NULL)), (DECODE (LEGISLATION_INFO_TYPE, 'MX Social Security Information', LEGISLATION_INFO1, NULL)), (DECODE (LEGISLATION_INFO_TYPE, 'MX Social Security Information', LEGISLATION_INFO2, NULL)), (DECODE (LEGISLATION_INFO_TYPE, 'MX Social Security Information', LEGISLATION_INFO3, NULL)), (DECODE (LEGISLATION_INFO_TYPE, 'MX Social Security Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEGISLATION_INFO4), NULL)), (DECODE (LEGISLATION_INFO_TYPE, 'MX Social Security Information', FND_NUMBER.CANONICAL_TO_NUMBER(LEGISLATION_INFO5), NULL)), (DECODE (LEGISLATION_INFO_TYPE, 'MX Tax Adjustment Parameters', FND_NUMBER.CANONICAL_TO_NUMBER(LEGISLATION_INFO1), NULL)),  
 (DECODE (LEGISLATION_INFO_TYPE,  
      'MX Annualization Factor', LEGISLATION_INFO_TYPE || '.' || LEGISLATION_INFO1 || '.' || LEGISLATION_INFO2,  
      'MX Minimum Wage Information', LEGISLATION_INFO_TYPE || '.' || LEGISLATION_INFO1 || '.' || LEGISLATION_INFO2,  
      'MX Social Security Information', LEGISLATION_INFO_TYPE || '.' || LEGISLATION_INFO1 || '.' || LEGISLATION_INFO2 || '.' || LEGISLATION_INFO3 || '.' || LEGISLATION_INFO4 || '.' || LEGISLATION_INFO5,  
      'MX Tax Adjustment Parameters', LEGISLATION_INFO_TYPE || '.' || LEGISLATION_INFO1, NULL)) 
 FROM PAY_MX_LEGISLATION_INFO_F

View Text - HTML Formatted

SELECT ROWID
, LEGISLATION_INFO_TYPE
, (DECODE (LEGISLATION_INFO_TYPE
, 'MX ANNUALIZATION FACTOR'
, LEGISLATION_INFO1
, NULL))
, (DECODE (LEGISLATION_INFO_TYPE
, 'MX ANNUALIZATION FACTOR'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEGISLATION_INFO2)
, NULL))
, (DECODE (LEGISLATION_INFO_TYPE
, 'MX MINIMUM WAGE INFORMATION'
, LEGISLATION_INFO1
, NULL))
, (DECODE (LEGISLATION_INFO_TYPE
, 'MX MINIMUM WAGE INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEGISLATION_INFO2)
, NULL))
, (DECODE (LEGISLATION_INFO_TYPE
, 'MX SOCIAL SECURITY INFORMATION'
, LEGISLATION_INFO1
, NULL))
, (DECODE (LEGISLATION_INFO_TYPE
, 'MX SOCIAL SECURITY INFORMATION'
, LEGISLATION_INFO2
, NULL))
, (DECODE (LEGISLATION_INFO_TYPE
, 'MX SOCIAL SECURITY INFORMATION'
, LEGISLATION_INFO3
, NULL))
, (DECODE (LEGISLATION_INFO_TYPE
, 'MX SOCIAL SECURITY INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEGISLATION_INFO4)
, NULL))
, (DECODE (LEGISLATION_INFO_TYPE
, 'MX SOCIAL SECURITY INFORMATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEGISLATION_INFO5)
, NULL))
, (DECODE (LEGISLATION_INFO_TYPE
, 'MX TAX ADJUSTMENT PARAMETERS'
, FND_NUMBER.CANONICAL_TO_NUMBER(LEGISLATION_INFO1)
, NULL))
, (DECODE (LEGISLATION_INFO_TYPE
, 'MX ANNUALIZATION FACTOR'
, LEGISLATION_INFO_TYPE || '.' || LEGISLATION_INFO1 || '.' || LEGISLATION_INFO2
, 'MX MINIMUM WAGE INFORMATION'
, LEGISLATION_INFO_TYPE || '.' || LEGISLATION_INFO1 || '.' || LEGISLATION_INFO2
, 'MX SOCIAL SECURITY INFORMATION'
, LEGISLATION_INFO_TYPE || '.' || LEGISLATION_INFO1 || '.' || LEGISLATION_INFO2 || '.' || LEGISLATION_INFO3 || '.' || LEGISLATION_INFO4 || '.' || LEGISLATION_INFO5
, 'MX TAX ADJUSTMENT PARAMETERS'
, LEGISLATION_INFO_TYPE || '.' || LEGISLATION_INFO1
, NULL))
FROM PAY_MX_LEGISLATION_INFO_F