VIEW: APPS.PAY_ELEMENT_TEMPLATES_CONF_DFV

Source

View Text - Preformatted

SELECT ROWID, CONFIGURATION_INFO_CATEGORY, (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Fixed Allowance', CONFIGURATION_INFORMATION1, 'IN Actual Expense Allowances', CONFIGURATION_INFORMATION1, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Actual Expense Allowances', CONFIGURATION_INFORMATION2, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Leave Travel Concession', CONFIGURATION_INFORMATION2, 'IN Fringe Benefits', CONFIGURATION_INFORMATION2, 'IN Fixed Allowance', CONFIGURATION_INFORMATION4, 'IN Actual Expense Allowances', CONFIGURATION_INFORMATION3, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Pension Fund 80CCD', CONFIGURATION_INFORMATION1, 'IN Fringe Benefits', CONFIGURATION_INFORMATION4, 'IN Fixed Allowance', CONFIGURATION_INFORMATION2, 'IN Earnings', CONFIGURATION_INFORMATION1, 'IN Actual Expense Allowances', CONFIGURATION_INFORMATION4, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Actual Expense Allowances', CONFIGURATION_INFORMATION5, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Actual Expense Allowances', CONFIGURATION_INFORMATION6, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Actual Expense Allowances', CONFIGURATION_INFORMATION7, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Actual Expense Allowances', CONFIGURATION_INFORMATION8, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Actual Expense Allowances', CONFIGURATION_INFORMATION9, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Transfer of Company Assets', CONFIGURATION_INFORMATION1, 'IN Other Perquisites', CONFIGURATION_INFORMATION1, 'IN Motor Car Perquisite', CONFIGURATION_INFORMATION1, 'IN Lunch Perquisite', CONFIGURATION_INFORMATION1, 'IN Loan at Concessional Rate', CONFIGURATION_INFORMATION1, 'IN Leave Travel Concession', CONFIGURATION_INFORMATION1, 'IN Free Education', CONFIGURATION_INFORMATION1, 'IN Company Movable Assets', CONFIGURATION_INFORMATION1, 'IN Company Accommodation', CONFIGURATION_INFORMATION1, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Transfer of Company Assets', CONFIGURATION_INFORMATION2, 'IN Other Perquisites', CONFIGURATION_INFORMATION2, 'IN Lunch Perquisite', CONFIGURATION_INFORMATION2, 'IN Loan at Concessional Rate', CONFIGURATION_INFORMATION2, 'IN Free Education', CONFIGURATION_INFORMATION2, 'IN Company Movable Assets', CONFIGURATION_INFORMATION2, 'IN Company Accommodation', CONFIGURATION_INFORMATION2, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Other Perquisites', CONFIGURATION_INFORMATION4, 'IN Free Education', CONFIGURATION_INFORMATION4, 'IN Company Accommodation', CONFIGURATION_INFORMATION4, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Earnings', CONFIGURATION_INFORMATION2, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Earnings', CONFIGURATION_INFORMATION3, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Earnings', CONFIGURATION_INFORMATION4, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Earnings', CONFIGURATION_INFORMATION5, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Earnings', CONFIGURATION_INFORMATION13, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Earnings', CONFIGURATION_INFORMATION6, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Earnings', CONFIGURATION_INFORMATION7, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Earnings', CONFIGURATION_INFORMATION8, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Earnings', CONFIGURATION_INFORMATION9, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Earnings', CONFIGURATION_INFORMATION10, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Earnings', CONFIGURATION_INFORMATION11, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Earnings', CONFIGURATION_INFORMATION12, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Fixed Allowance', CONFIGURATION_INFORMATION3, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Fringe Benefits', CONFIGURATION_INFORMATION1, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Fringe Benefits', CONFIGURATION_INFORMATION3, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Fringe Benefits', CONFIGURATION_INFORMATION5, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Motor Car Perquisite', CONFIGURATION_INFORMATION2, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Other Perquisites', CONFIGURATION_INFORMATION3, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'IN Other Perquisites', CONFIGURATION_INFORMATION5, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'MX Percentage of Earnings', CONFIGURATION_INFORMATION1, 'MX Hours X Rate', CONFIGURATION_INFORMATION1, 'MX Flat Amount', CONFIGURATION_INFORMATION1, 'MX Days X Rate', CONFIGURATION_INFORMATION1, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'MX Percentage of Earnings', CONFIGURATION_INFORMATION2, 'MX Hours X Rate', CONFIGURATION_INFORMATION2, 'MX Flat Amount', CONFIGURATION_INFORMATION2, 'MX Days X Rate', CONFIGURATION_INFORMATION2, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'MX Percentage of Earnings', CONFIGURATION_INFORMATION3, 'MX Hours X Rate', CONFIGURATION_INFORMATION3, 'MX Flat Amount', CONFIGURATION_INFORMATION3, 'MX Days X Rate', CONFIGURATION_INFORMATION3, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'MX Percentage of Earnings', CONFIGURATION_INFORMATION4, 'MX Hours X Rate', CONFIGURATION_INFORMATION4, 'MX Flat Amount', CONFIGURATION_INFORMATION4, 'MX Days X Rate', CONFIGURATION_INFORMATION4, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'MX Days X Rate', CONFIGURATION_INFORMATION5, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'MX Days X Rate', CONFIGURATION_INFORMATION6, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'MX Days X Rate', CONFIGURATION_INFORMATION7, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'MX Percentage of Earnings', CONFIGURATION_INFORMATION8, 'MX Hours X Rate', CONFIGURATION_INFORMATION8, 'MX Flat Amount', CONFIGURATION_INFORMATION8, 'MX Days X Rate', CONFIGURATION_INFORMATION8, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'MX Days X Rate', CONFIGURATION_INFORMATION9, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'MX Percentage Deduction', CONFIGURATION_INFORMATION1, 'MX Flat Amount Deduction', CONFIGURATION_INFORMATION1, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'MX Percentage Deduction', CONFIGURATION_INFORMATION2, 'MX Flat Amount Deduction', CONFIGURATION_INFORMATION2, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'MX Percentage Deduction', CONFIGURATION_INFORMATION3, 'MX Flat Amount Deduction', CONFIGURATION_INFORMATION3, NULL)), (DECODE (CONFIGURATION_INFO_CATEGORY, 'MX Percentage Deduction', CONFIGURATION_INFORMATION4, 'MX Flat Amount Deduction', CONFIGURATION_INFORMATION4, NULL)),  
 (DECODE (CONFIGURATION_INFO_CATEGORY,  
      'IN Actual Expense Allowances', CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4 || '.' || CONFIGURATION_INFORMATION5 || '.' || CONFIGURATION_INFORMATION6 || '.' || CONFIGURATION_INFORMATION7 || '.' || CONFIGURATION_INFORMATION8 || '.' || CONFIGURATION_INFORMATION9,  
      'IN Company Accommodation', CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION4,  
      'IN Company Movable Assets', CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2,  
      'IN Earnings', CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4 || '.' || CONFIGURATION_INFORMATION5 || '.' || CONFIGURATION_INFORMATION13 || '.' || CONFIGURATION_INFORMATION6 || '.' || CONFIGURATION_INFORMATION7 || '.' || CONFIGURATION_INFORMATION8 || '.' || CONFIGURATION_INFORMATION9 || '.' || CONFIGURATION_INFORMATION10 || '.' || CONFIGURATION_INFORMATION11 || '.' || CONFIGURATION_INFORMATION12,  
      'IN Fixed Allowance', CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4,  
      'IN Free Education', CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION4,  
      'IN Fringe Benefits', CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4 || '.' || CONFIGURATION_INFORMATION5,  
      'IN Leave Travel Concession', CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2,  
      'IN Loan at Concessional Rate', CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2,  
      'IN Lunch Perquisite', CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2,  
      'IN Motor Car Perquisite', CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2,  
      'IN Other Perquisites', CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4 || '.' || CONFIGURATION_INFORMATION5,  
      'IN Pension Fund 80CCD', CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1,  
      'IN Transfer of Company Assets', CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2,  
      'MX Days X Rate', CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4 || '.' || CONFIGURATION_INFORMATION5 || '.' || CONFIGURATION_INFORMATION6 || '.' || CONFIGURATION_INFORMATION7 || '.' || CONFIGURATION_INFORMATION8 || '.' || CONFIGURATION_INFORMATION9,  
      'MX Flat Amount', CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4 || '.' || CONFIGURATION_INFORMATION8,  
      'MX Flat Amount Deduction', CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4,  
      'MX Hours X Rate', CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4 || '.' || CONFIGURATION_INFORMATION8,  
      'MX Percentage Deduction', CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4,  
      'MX Percentage of Earnings', CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4 || '.' || CONFIGURATION_INFORMATION8, NULL)) 
 FROM PAY_ELEMENT_TEMPLATES

View Text - HTML Formatted

SELECT ROWID
, CONFIGURATION_INFO_CATEGORY
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN FIXED ALLOWANCE'
, CONFIGURATION_INFORMATION1
, 'IN ACTUAL EXPENSE ALLOWANCES'
, CONFIGURATION_INFORMATION1
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN ACTUAL EXPENSE ALLOWANCES'
, CONFIGURATION_INFORMATION2
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN LEAVE TRAVEL CONCESSION'
, CONFIGURATION_INFORMATION2
, 'IN FRINGE BENEFITS'
, CONFIGURATION_INFORMATION2
, 'IN FIXED ALLOWANCE'
, CONFIGURATION_INFORMATION4
, 'IN ACTUAL EXPENSE ALLOWANCES'
, CONFIGURATION_INFORMATION3
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN PENSION FUND 80CCD'
, CONFIGURATION_INFORMATION1
, 'IN FRINGE BENEFITS'
, CONFIGURATION_INFORMATION4
, 'IN FIXED ALLOWANCE'
, CONFIGURATION_INFORMATION2
, 'IN EARNINGS'
, CONFIGURATION_INFORMATION1
, 'IN ACTUAL EXPENSE ALLOWANCES'
, CONFIGURATION_INFORMATION4
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN ACTUAL EXPENSE ALLOWANCES'
, CONFIGURATION_INFORMATION5
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN ACTUAL EXPENSE ALLOWANCES'
, CONFIGURATION_INFORMATION6
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN ACTUAL EXPENSE ALLOWANCES'
, CONFIGURATION_INFORMATION7
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN ACTUAL EXPENSE ALLOWANCES'
, CONFIGURATION_INFORMATION8
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN ACTUAL EXPENSE ALLOWANCES'
, CONFIGURATION_INFORMATION9
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN TRANSFER OF COMPANY ASSETS'
, CONFIGURATION_INFORMATION1
, 'IN OTHER PERQUISITES'
, CONFIGURATION_INFORMATION1
, 'IN MOTOR CAR PERQUISITE'
, CONFIGURATION_INFORMATION1
, 'IN LUNCH PERQUISITE'
, CONFIGURATION_INFORMATION1
, 'IN LOAN AT CONCESSIONAL RATE'
, CONFIGURATION_INFORMATION1
, 'IN LEAVE TRAVEL CONCESSION'
, CONFIGURATION_INFORMATION1
, 'IN FREE EDUCATION'
, CONFIGURATION_INFORMATION1
, 'IN COMPANY MOVABLE ASSETS'
, CONFIGURATION_INFORMATION1
, 'IN COMPANY ACCOMMODATION'
, CONFIGURATION_INFORMATION1
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN TRANSFER OF COMPANY ASSETS'
, CONFIGURATION_INFORMATION2
, 'IN OTHER PERQUISITES'
, CONFIGURATION_INFORMATION2
, 'IN LUNCH PERQUISITE'
, CONFIGURATION_INFORMATION2
, 'IN LOAN AT CONCESSIONAL RATE'
, CONFIGURATION_INFORMATION2
, 'IN FREE EDUCATION'
, CONFIGURATION_INFORMATION2
, 'IN COMPANY MOVABLE ASSETS'
, CONFIGURATION_INFORMATION2
, 'IN COMPANY ACCOMMODATION'
, CONFIGURATION_INFORMATION2
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN OTHER PERQUISITES'
, CONFIGURATION_INFORMATION4
, 'IN FREE EDUCATION'
, CONFIGURATION_INFORMATION4
, 'IN COMPANY ACCOMMODATION'
, CONFIGURATION_INFORMATION4
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN EARNINGS'
, CONFIGURATION_INFORMATION2
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN EARNINGS'
, CONFIGURATION_INFORMATION3
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN EARNINGS'
, CONFIGURATION_INFORMATION4
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN EARNINGS'
, CONFIGURATION_INFORMATION5
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN EARNINGS'
, CONFIGURATION_INFORMATION13
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN EARNINGS'
, CONFIGURATION_INFORMATION6
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN EARNINGS'
, CONFIGURATION_INFORMATION7
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN EARNINGS'
, CONFIGURATION_INFORMATION8
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN EARNINGS'
, CONFIGURATION_INFORMATION9
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN EARNINGS'
, CONFIGURATION_INFORMATION10
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN EARNINGS'
, CONFIGURATION_INFORMATION11
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN EARNINGS'
, CONFIGURATION_INFORMATION12
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN FIXED ALLOWANCE'
, CONFIGURATION_INFORMATION3
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN FRINGE BENEFITS'
, CONFIGURATION_INFORMATION1
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN FRINGE BENEFITS'
, CONFIGURATION_INFORMATION3
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN FRINGE BENEFITS'
, CONFIGURATION_INFORMATION5
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN MOTOR CAR PERQUISITE'
, CONFIGURATION_INFORMATION2
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN OTHER PERQUISITES'
, CONFIGURATION_INFORMATION3
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN OTHER PERQUISITES'
, CONFIGURATION_INFORMATION5
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'MX PERCENTAGE OF EARNINGS'
, CONFIGURATION_INFORMATION1
, 'MX HOURS X RATE'
, CONFIGURATION_INFORMATION1
, 'MX FLAT AMOUNT'
, CONFIGURATION_INFORMATION1
, 'MX DAYS X RATE'
, CONFIGURATION_INFORMATION1
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'MX PERCENTAGE OF EARNINGS'
, CONFIGURATION_INFORMATION2
, 'MX HOURS X RATE'
, CONFIGURATION_INFORMATION2
, 'MX FLAT AMOUNT'
, CONFIGURATION_INFORMATION2
, 'MX DAYS X RATE'
, CONFIGURATION_INFORMATION2
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'MX PERCENTAGE OF EARNINGS'
, CONFIGURATION_INFORMATION3
, 'MX HOURS X RATE'
, CONFIGURATION_INFORMATION3
, 'MX FLAT AMOUNT'
, CONFIGURATION_INFORMATION3
, 'MX DAYS X RATE'
, CONFIGURATION_INFORMATION3
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'MX PERCENTAGE OF EARNINGS'
, CONFIGURATION_INFORMATION4
, 'MX HOURS X RATE'
, CONFIGURATION_INFORMATION4
, 'MX FLAT AMOUNT'
, CONFIGURATION_INFORMATION4
, 'MX DAYS X RATE'
, CONFIGURATION_INFORMATION4
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'MX DAYS X RATE'
, CONFIGURATION_INFORMATION5
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'MX DAYS X RATE'
, CONFIGURATION_INFORMATION6
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'MX DAYS X RATE'
, CONFIGURATION_INFORMATION7
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'MX PERCENTAGE OF EARNINGS'
, CONFIGURATION_INFORMATION8
, 'MX HOURS X RATE'
, CONFIGURATION_INFORMATION8
, 'MX FLAT AMOUNT'
, CONFIGURATION_INFORMATION8
, 'MX DAYS X RATE'
, CONFIGURATION_INFORMATION8
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'MX DAYS X RATE'
, CONFIGURATION_INFORMATION9
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'MX PERCENTAGE DEDUCTION'
, CONFIGURATION_INFORMATION1
, 'MX FLAT AMOUNT DEDUCTION'
, CONFIGURATION_INFORMATION1
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'MX PERCENTAGE DEDUCTION'
, CONFIGURATION_INFORMATION2
, 'MX FLAT AMOUNT DEDUCTION'
, CONFIGURATION_INFORMATION2
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'MX PERCENTAGE DEDUCTION'
, CONFIGURATION_INFORMATION3
, 'MX FLAT AMOUNT DEDUCTION'
, CONFIGURATION_INFORMATION3
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'MX PERCENTAGE DEDUCTION'
, CONFIGURATION_INFORMATION4
, 'MX FLAT AMOUNT DEDUCTION'
, CONFIGURATION_INFORMATION4
, NULL))
, (DECODE (CONFIGURATION_INFO_CATEGORY
, 'IN ACTUAL EXPENSE ALLOWANCES'
, CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4 || '.' || CONFIGURATION_INFORMATION5 || '.' || CONFIGURATION_INFORMATION6 || '.' || CONFIGURATION_INFORMATION7 || '.' || CONFIGURATION_INFORMATION8 || '.' || CONFIGURATION_INFORMATION9
, 'IN COMPANY ACCOMMODATION'
, CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION4
, 'IN COMPANY MOVABLE ASSETS'
, CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2
, 'IN EARNINGS'
, CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4 || '.' || CONFIGURATION_INFORMATION5 || '.' || CONFIGURATION_INFORMATION13 || '.' || CONFIGURATION_INFORMATION6 || '.' || CONFIGURATION_INFORMATION7 || '.' || CONFIGURATION_INFORMATION8 || '.' || CONFIGURATION_INFORMATION9 || '.' || CONFIGURATION_INFORMATION10 || '.' || CONFIGURATION_INFORMATION11 || '.' || CONFIGURATION_INFORMATION12
, 'IN FIXED ALLOWANCE'
, CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4
, 'IN FREE EDUCATION'
, CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION4
, 'IN FRINGE BENEFITS'
, CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4 || '.' || CONFIGURATION_INFORMATION5
, 'IN LEAVE TRAVEL CONCESSION'
, CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2
, 'IN LOAN AT CONCESSIONAL RATE'
, CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2
, 'IN LUNCH PERQUISITE'
, CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2
, 'IN MOTOR CAR PERQUISITE'
, CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2
, 'IN OTHER PERQUISITES'
, CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4 || '.' || CONFIGURATION_INFORMATION5
, 'IN PENSION FUND 80CCD'
, CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1
, 'IN TRANSFER OF COMPANY ASSETS'
, CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2
, 'MX DAYS X RATE'
, CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4 || '.' || CONFIGURATION_INFORMATION5 || '.' || CONFIGURATION_INFORMATION6 || '.' || CONFIGURATION_INFORMATION7 || '.' || CONFIGURATION_INFORMATION8 || '.' || CONFIGURATION_INFORMATION9
, 'MX FLAT AMOUNT'
, CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4 || '.' || CONFIGURATION_INFORMATION8
, 'MX FLAT AMOUNT DEDUCTION'
, CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4
, 'MX HOURS X RATE'
, CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4 || '.' || CONFIGURATION_INFORMATION8
, 'MX PERCENTAGE DEDUCTION'
, CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4
, 'MX PERCENTAGE OF EARNINGS'
, CONFIGURATION_INFO_CATEGORY || '.' || CONFIGURATION_INFORMATION1 || '.' || CONFIGURATION_INFORMATION2 || '.' || CONFIGURATION_INFORMATION3 || '.' || CONFIGURATION_INFORMATION4 || '.' || CONFIGURATION_INFORMATION8
, NULL))
FROM PAY_ELEMENT_TEMPLATES