eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.PAY_ELEMENT_TYPE_EXTRA_INF_DFV

Source

View Text - Preformatted


SELECT ROWID, EEI_INFORMATION_CATEGORY, EEI_INFORMATION1, EEI_INFORMATION1, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_NL_PRE_TAX_DEDUCTIONS', EEI_INFORMATION1, 'PQP_NL_PGGM_DEDUCTION', EEI_INFORMATION1, 'PQP_NL_ABP_DEDUCTION', EEI_INFORMATION1, 'PQP_GB_PENSION_SCHEME_INFO', EEI_INFORMATION1, 'HU_PENSION_SCHEME_INFO', EEI_INFORMATION1, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_NL_SAVINGS_DEDUCTIONS', EEI_INFORMATION3, 'PQP_NL_PRE_TAX_DEDUCTIONS', EEI_INFORMATION3, 'PQP_NL_PGGM_DEDUCTION', EEI_INFORMATION3, 'PQP_NL_ABP_DEDUCTION', EEI_INFORMATION3, 'PQP_GB_PENSION_SCHEME_INFO', EEI_INFORMATION2, 'HU_PENSION_SCHEME_INFO', EEI_INFORMATION2, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_NL_SAVINGS_DEDUCTIONS', EEI_INFORMATION2, 'PQP_NL_PRE_TAX_DEDUCTIONS', EEI_INFORMATION2, 'PQP_NL_PGGM_DEDUCTION', EEI_INFORMATION2, 'PQP_NL_ABP_DEDUCTION', EEI_INFORMATION2, 'PQP_GB_PENSION_SCHEME_INFO', EEI_INFORMATION3, 'HU_PENSION_SCHEME_INFO', EEI_INFORMATION3, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_NL_SAVINGS_DEDUCTIONS', EEI_INFORMATION4, 'PQP_NL_PRE_TAX_DEDUCTIONS', EEI_INFORMATION4, 'PQP_NL_ABP_DEDUCTION', EEI_INFORMATION4, 'PQP_GB_PENSION_SCHEME_INFO', EEI_INFORMATION4, 'HU_PENSION_SCHEME_INFO', EEI_INFORMATION4, NULL)), EEI_INFORMATION5, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_PENSION_SCHEME_INFO', EEI_INFORMATION6, 'HU_PENSION_SCHEME_INFO', EEI_INFORMATION6, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_PENSION_SCHEME_INFO', EEI_INFORMATION7, 'HU_PENSION_SCHEME_INFO', EEI_INFORMATION7, NULL)), EEI_INFORMATION8, EEI_INFORMATION9, EEI_INFORMATION10, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_PENSION_SCHEME_INFO', EEI_INFORMATION11, 'HU_PENSION_SCHEME_INFO', EEI_INFORMATION11, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_NL_SAVINGS_DEDUCTIONS', EEI_INFORMATION10, 'PQP_NL_PRE_TAX_DEDUCTIONS', EEI_INFORMATION10, 'PQP_NL_PGGM_DEDUCTION', EEI_INFORMATION4, 'PQP_NL_ABP_DEDUCTION', EEI_INFORMATION9, 'PQP_GB_PENSION_SCHEME_INFO', EEI_INFORMATION18, 'HU_PENSION_SCHEME_INFO', EEI_INFORMATION12, NULL)), EEI_INFORMATION13, EEI_INFORMATION1, EEI_INFORMATION2, EEI_INFORMATION3, EEI_INFORMATION4, EEI_INFORMATION5, EEI_INFORMATION6, EEI_INFORMATION7, EEI_INFORMATION8, EEI_INFORMATION1, EEI_INFORMATION1, EEI_INFORMATION2, EEI_INFORMATION1, (DECODE (EEI_INFORMATION_CATEGORY, 'NO_EOY_REPORTING_CODE_MAPPING', EEI_INFORMATION4, 'NO_EMPLOYEE_DEDUCTION_REPORT', EEI_INFORMATION2, NULL)), EEI_INFORMATION3, EEI_INFORMATION4, EEI_INFORMATION5, (DECODE (EEI_INFORMATION_CATEGORY, 'NO_EOY_REPORTING_CODE_MAPPING', FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION1), NULL)), EEI_INFORMATION2, EEI_INFORMATION3, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_OSP_ABSENCE_PLAN_INFO', EEI_INFORMATION19, 'PQP_GB_OMP_ABSENCE_PLAN_INFO', EEI_INFORMATION19, 'NO_EOY_REPORTING_CODE_MAPPING', EEI_INFORMATION17, NULL)), EEI_INFORMATION5, EEI_INFORMATION6, EEI_INFORMATION7, EEI_INFORMATION8, EEI_INFORMATION9, EEI_INFORMATION10, EEI_INFORMATION11, EEI_INFORMATION12, EEI_INFORMATION13, EEI_INFORMATION14, EEI_INFORMATION15, EEI_INFORMATION16, EEI_INFORMATION1, EEI_INFORMATION2, EEI_INFORMATION3, EEI_INFORMATION4, EEI_INFORMATION5, EEI_INFORMATION1, (DECODE (EEI_INFORMATION_CATEGORY, 'PAY_IN_BONUS_INFO_DFF', FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION2), NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PAY_US_TAX_CALCULATION_METHOD', EEI_INFORMATION3, 'PAY_US_GARN_PROCESSING_RULE', EEI_INFORMATION10, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PAY_US_TAX_CALCULATION_METHOD', EEI_INFORMATION4, 'PAY_US_GARN_PROCESSING_RULE', EEI_INFORMATION11, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PAY_US_GARN_PROCESSING_RULE', FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION12), NULL)), EEI_INFORMATION13, (DECODE (EEI_INFORMATION_CATEGORY, 'PAY_US_GARN_PROCESSING_RULE', FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION14), NULL)), EEI_INFORMATION1, EEI_INFORMATION4, EEI_INFORMATION6, EEI_INFORMATION2, EEI_INFORMATION5, EEI_INFORMATION1, EEI_INFORMATION2, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_OSP_ABSENCE_PLAN_INFO', EEI_INFORMATION1, 'PQP_GB_OMP_ABSENCE_PLAN_INFO', EEI_INFORMATION1, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_OSP_ABSENCE_PLAN_INFO', EEI_INFORMATION2, 'PQP_GB_OMP_ABSENCE_PLAN_INFO', EEI_INFORMATION2, NULL)), EEI_INFORMATION3, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_OMP_ABSENCE_PLAN_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION4), NULL)), EEI_INFORMATION5, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_OMP_ABSENCE_PLAN_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION6), NULL)), EEI_INFORMATION7, EEI_INFORMATION8, EEI_INFORMATION9, EEI_INFORMATION11, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_OSP_ABSENCE_PLAN_INFO', EEI_INFORMATION10, 'PQP_GB_OMP_ABSENCE_PLAN_INFO', EEI_INFORMATION12, NULL)), EEI_INFORMATION13, EEI_INFORMATION14, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_OMP_ABSENCE_PLAN_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION15), NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_OSP_ABSENCE_PLAN_INFO', EEI_INFORMATION15, 'PQP_GB_OMP_ABSENCE_PLAN_INFO', EEI_INFORMATION16, NULL)), EEI_INFORMATION17, EEI_INFORMATION18, EEI_INFORMATION20, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_OSP_ABSENCE_PLAN_INFO', EEI_INFORMATION27, 'PQP_GB_OMP_ABSENCE_PLAN_INFO', EEI_INFORMATION27, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_OSP_ABSENCE_PLAN_INFO', EEI_INFORMATION28, 'PQP_GB_OMP_ABSENCE_PLAN_INFO', EEI_INFORMATION28, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_OSP_ABSENCE_PLAN_INFO', EEI_INFORMATION29, 'PQP_GB_OMP_ABSENCE_PLAN_INFO', EEI_INFORMATION29, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_OSP_ABSENCE_PLAN_INFO', EEI_INFORMATION30, 'PQP_GB_OMP_ABSENCE_PLAN_INFO', EEI_INFORMATION30, NULL)), EEI_INFORMATION3, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_OSP_ABSENCE_PLAN_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION4), NULL)), EEI_INFORMATION5, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_OSP_ABSENCE_PLAN_INFO', TO_DATE(EEI_INFORMATION6, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_OSP_ABSENCE_PLAN_INFO', TO_DATE(EEI_INFORMATION7, 'YYYY/MM/DD HH24:MI:SS'), NULL)), EEI_INFORMATION8, EEI_INFORMATION9, EEI_INFORMATION11, EEI_INFORMATION12, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_OSP_ABSENCE_PLAN_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION13), NULL)), EEI_INFORMATION16, EEI_INFORMATION17, EEI_INFORMATION18, EEI_INFORMATION26, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_OSP_ABSENCE_PLAN_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION20), NULL)), EEI_INFORMATION21, EEI_INFORMATION22, EEI_INFORMATION23, EEI_INFORMATION24, EEI_INFORMATION14, EEI_INFORMATION25, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_PENSERV_BONUS_INFO', EEI_INFORMATION1, 'PQP_GB_PENSERV_ALLOWANCE_INFO', EEI_INFORMATION1, NULL)), EEI_INFORMATION2, EEI_INFORMATION3, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_PENSERV_BONUS_INFO', EEI_INFORMATION4, 'PQP_GB_PENSERV_ALLOWANCE_INFO', EEI_INFORMATION4, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_PENSERV_BONUS_INFO', EEI_INFORMATION5, 'PQP_GB_PENSERV_ALLOWANCE_INFO', EEI_INFORMATION5, NULL)), EEI_INFORMATION6, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_PENSERV_BONUS_INFO', EEI_INFORMATION6, 'PQP_GB_PENSERV_ALLOWANCE_INFO', EEI_INFORMATION7, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_PENSERV_BONUS_INFO', EEI_INFORMATION7, 'PQP_GB_PENSERV_ALLOWANCE_INFO', EEI_INFORMATION8, NULL)), EEI_INFORMATION2, EEI_INFORMATION3, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_GB_PENSION_SCHEME_INFO', TO_DATE(EEI_INFORMATION5, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_NL_SAVINGS_DEDUCTIONS', EEI_INFORMATION11, 'PQP_GB_PENSION_SCHEME_INFO', EEI_INFORMATION8, NULL)), EEI_INFORMATION9, EEI_INFORMATION19, EEI_INFORMATION10, EEI_INFORMATION12, EEI_INFORMATION13, EEI_INFORMATION14, EEI_INFORMATION15, EEI_INFORMATION20, EEI_INFORMATION16, EEI_INFORMATION17, EEI_INFORMATION21, EEI_INFORMATION22, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_NL_SAVINGS_DEDUCTIONS', EEI_INFORMATION5, 'PQP_NL_PRE_TAX_DEDUCTIONS', EEI_INFORMATION5, 'PQP_NL_ABP_DEDUCTION', EEI_INFORMATION5, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_NL_SAVINGS_DEDUCTIONS', EEI_INFORMATION6, 'PQP_NL_PRE_TAX_DEDUCTIONS', EEI_INFORMATION6, 'PQP_NL_ABP_DEDUCTION', EEI_INFORMATION6, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_NL_SAVINGS_DEDUCTIONS', EEI_INFORMATION7, 'PQP_NL_PRE_TAX_DEDUCTIONS', EEI_INFORMATION7, 'PQP_NL_ABP_DEDUCTION', EEI_INFORMATION7, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_NL_SAVINGS_DEDUCTIONS', EEI_INFORMATION8, 'PQP_NL_PRE_TAX_DEDUCTIONS', EEI_INFORMATION8, 'PQP_NL_ABP_DEDUCTION', EEI_INFORMATION8, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_NL_PGGM_DEDUCTION', EEI_INFORMATION5, 'PQP_NL_ABP_DEDUCTION', EEI_INFORMATION10, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_NL_PGGM_DEDUCTION', EEI_INFORMATION6, 'PQP_NL_ABP_DEDUCTION', EEI_INFORMATION11, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_NL_PGGM_DEDUCTION', EEI_INFORMATION7, 'PQP_NL_ABP_DEDUCTION', EEI_INFORMATION12, NULL)), EEI_INFORMATION13, EEI_INFORMATION14, EEI_INFORMATION15, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_NL_PGGM_DEDUCTION', EEI_INFORMATION8, 'PQP_NL_ABP_DEDUCTION', EEI_INFORMATION16, NULL)), EEI_INFORMATION17, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_NL_PGGM_DEDUCTION', EEI_INFORMATION11, 'PQP_NL_ABP_DEDUCTION', EEI_INFORMATION18, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_NL_PGGM_DEDUCTION', EEI_INFORMATION12, 'PQP_NL_ABP_DEDUCTION', EEI_INFORMATION19, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_NL_PGGM_DEDUCTION', EEI_INFORMATION13, 'PQP_NL_ABP_DEDUCTION', EEI_INFORMATION20, NULL)), (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_NL_PGGM_DEDUCTION', EEI_INFORMATION14, 'PQP_NL_ABP_DEDUCTION', EEI_INFORMATION21, NULL)), EEI_INFORMATION9, EEI_INFORMATION10, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_NL_SAVINGS_DEDUCTIONS', EEI_INFORMATION9, 'PQP_NL_PRE_TAX_DEDUCTIONS', EEI_INFORMATION9, NULL)), EEI_INFORMATION1, EEI_INFORMATION1, EEI_INFORMATION2, EEI_INFORMATION3, EEI_INFORMATION4, EEI_INFORMATION1, EEI_INFORMATION2, EEI_INFORMATION3, EEI_INFORMATION4, EEI_INFORMATION5, EEI_INFORMATION6, EEI_INFORMATION7, (DECODE (EEI_INFORMATION_CATEGORY, 'PQP_UK_ELEMENT_ATTRIBUTION', FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION8), NULL)), EEI_INFORMATION9, EEI_INFORMATION11, EEI_INFORMATION10, EEI_INFORMATION12, EEI_INFORMATION13, EEI_INFORMATION14, EEI_INFORMATION15, EEI_INFORMATION16, EEI_INFORMATION17, EEI_INFORMATION18, EEI_INFORMATION19, EEI_INFORMATION1, EEI_INFORMATION2, EEI_INFORMATION1, EEI_INFORMATION2, EEI_INFORMATION3, EEI_INFORMATION4, EEI_INFORMATION3, EEI_INFORMATION4, EEI_INFORMATION5, EEI_INFORMATION1, EEI_INFORMATION2, EEI_INFORMATION3, EEI_INFORMATION10, EEI_INFORMATION3, EEI_INFORMATION1, EEI_INFORMATION2,  
 (DECODE (EEI_INFORMATION_CATEGORY,  
      'AU_RETRO_UPGRADE_INFO', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1,  
      'DEDUCTION_PROCESSING', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1,  
      'HU_PENSION_SCHEME_INFO', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8 || '.' || EEI_INFORMATION9 || '.' || EEI_INFORMATION10 || '.' || EEI_INFORMATION11 || '.' || EEI_INFORMATION12 || '.' || EEI_INFORMATION13,  
      'IE_PENSION_SCHEME_INFO', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8,  
      'MX_DEDUCTION_PROCESSING', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1,  
      'NO_ELEMENT_CODES', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2,  
      'NO_EMPLOYEE_DEDUCTION_REPORT', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5,  
      'NO_EOY_REPORTING_CODE_MAPPING', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION17 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8 || '.' || EEI_INFORMATION9 || '.' || EEI_INFORMATION10 || '.' || EEI_INFORMATION11 || '.' || EEI_INFORMATION12 || '.' || EEI_INFORMATION13 || '.' || EEI_INFORMATION14 || '.' || EEI_INFORMATION15 || '.' || EEI_INFORMATION16,  
      'NO_SSB_CODES', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5,  
      'PAY_IN_BONUS_INFO_DFF', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2,  
      'PAY_US_GARN_PROCESSING_RULE', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION10 || '.' || EEI_INFORMATION11 || '.' || EEI_INFORMATION12 || '.' || EEI_INFORMATION13 || '.' || EEI_INFORMATION14,  
      'PAY_US_INFORMATION_TIME', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1,  
      'PAY_US_ROTH_OPTIONS', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION6,  
      'PAY_US_TAX_CALCULATION_METHOD', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5,  
      'PQP_GB_ARREARAGE_INFO', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2,  
      'PQP_GB_OMP_ABSENCE_PLAN_INFO', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8 || '.' || EEI_INFORMATION9 || '.' || EEI_INFORMATION11 || '.' || EEI_INFORMATION12 || '.' || EEI_INFORMATION13 || '.' || EEI_INFORMATION14 || '.' || EEI_INFORMATION15 || '.' || EEI_INFORMATION16 || '.' || EEI_INFORMATION17 || '.' || EEI_INFORMATION18 || '.' || EEI_INFORMATION19 || '.' || EEI_INFORMATION20 || '.' || EEI_INFORMATION27 || '.' || EEI_INFORMATION28 || '.' || EEI_INFORMATION29 || '.' || EEI_INFORMATION30,  
      'PQP_GB_OSP_ABSENCE_PLAN_INFO', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8 || '.' || EEI_INFORMATION9 || '.' || EEI_INFORMATION10 || '.' || EEI_INFORMATION11 || '.' || EEI_INFORMATION12 || '.' || EEI_INFORMATION13 || '.' || EEI_INFORMATION19 || '.' || EEI_INFORMATION15 || '.' || EEI_INFORMATION16 || '.' || EEI_INFORMATION17 || '.' || EEI_INFORMATION18 || '.' || EEI_INFORMATION30 || '.' || EEI_INFORMATION29 || '.' || EEI_INFORMATION28 || '.' || EEI_INFORMATION27 || '.' || EEI_INFORMATION26 || '.' || EEI_INFORMATION20 || '.' || EEI_INFORMATION21 || '.' || EEI_INFORMATION22 || '.' || EEI_INFORMATION23 || '.' || EEI_INFORMATION24 || '.' || EEI_INFORMATION14 || '.' || EEI_INFORMATION25,  
      'PQP_GB_PENSERV_ALLOWANCE_INFO', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8,  
      'PQP_GB_PENSERV_BONUS_INFO', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7,  
      'PQP_GB_PENSION_SCHEME_INFO', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8 || '.' || EEI_INFORMATION9 || '.' || EEI_INFORMATION19 || '.' || EEI_INFORMATION10 || '.' || EEI_INFORMATION11 || '.' || EEI_INFORMATION12 || '.' || EEI_INFORMATION13 || '.' || EEI_INFORMATION14 || '.' || EEI_INFORMATION15 || '.' || EEI_INFORMATION20 || '.' || EEI_INFORMATION16 || '.' || EEI_INFORMATION17 || '.' || EEI_INFORMATION18 || '.' || EEI_INFORMATION21 || '.' || EEI_INFORMATION22,  
      'PQP_NL_ABP_DEDUCTION', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8 || '.' || EEI_INFORMATION9 || '.' || EEI_INFORMATION10 || '.' || EEI_INFORMATION11 || '.' || EEI_INFORMATION12 || '.' || EEI_INFORMATION13 || '.' || EEI_INFORMATION14 || '.' || EEI_INFORMATION15 || '.' || EEI_INFORMATION16 || '.' || EEI_INFORMATION17 || '.' || EEI_INFORMATION18 || '.' || EEI_INFORMATION19 || '.' || EEI_INFORMATION20 || '.' || EEI_INFORMATION21,  
      'PQP_NL_PGGM_DEDUCTION', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8 || '.' || EEI_INFORMATION9 || '.' || EEI_INFORMATION10 || '.' || EEI_INFORMATION11 || '.' || EEI_INFORMATION12 || '.' || EEI_INFORMATION13 || '.' || EEI_INFORMATION14,  
      'PQP_NL_PRE_TAX_DEDUCTIONS', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8 || '.' || EEI_INFORMATION9 || '.' || EEI_INFORMATION10,  
      'PQP_NL_SAVINGS_DEDUCTIONS', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8 || '.' || EEI_INFORMATION9 || '.' || EEI_INFORMATION10 || '.' || EEI_INFORMATION11,  
      'PQP_PROFESSIONAL_BODY_INFO', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4,  
      'PQP_UK_ELEMENT_ATTRIBUTION', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8 || '.' || EEI_INFORMATION9 || '.' || EEI_INFORMATION11 || '.' || EEI_INFORMATION10 || '.' || EEI_INFORMATION12 || '.' || EEI_INFORMATION13 || '.' || EEI_INFORMATION14 || '.' || EEI_INFORMATION15 || '.' || EEI_INFORMATION16 || '.' || EEI_INFORMATION17 || '.' || EEI_INFORMATION18 || '.' || EEI_INFORMATION19,  
      'PQP_UK_RATE_TYPE', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2,  
      'PQP_UK_UNION_INFO', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4,  
      'PQP_US_PRE_TAX_DEDUCTIONS', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION3,  
      'PQP_US_SRS_DEDUCTIONS', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5,  
      'PQP_VEHICLE_MILEAGE_INFO', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3,  
      'US_EARNINGS', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION10,  
      'US_TIAA_CREF_CONT_TYPES', EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2, NULL)) 
 FROM PAY_ELEMENT_TYPE_EXTRA_INFO

View Text - HTML Formatted

SELECT ROWID
, EEI_INFORMATION_CATEGORY
, EEI_INFORMATION1
, EEI_INFORMATION1
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_NL_PRE_TAX_DEDUCTIONS'
, EEI_INFORMATION1
, 'PQP_NL_PGGM_DEDUCTION'
, EEI_INFORMATION1
, 'PQP_NL_ABP_DEDUCTION'
, EEI_INFORMATION1
, 'PQP_GB_PENSION_SCHEME_INFO'
, EEI_INFORMATION1
, 'HU_PENSION_SCHEME_INFO'
, EEI_INFORMATION1
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_NL_SAVINGS_DEDUCTIONS'
, EEI_INFORMATION3
, 'PQP_NL_PRE_TAX_DEDUCTIONS'
, EEI_INFORMATION3
, 'PQP_NL_PGGM_DEDUCTION'
, EEI_INFORMATION3
, 'PQP_NL_ABP_DEDUCTION'
, EEI_INFORMATION3
, 'PQP_GB_PENSION_SCHEME_INFO'
, EEI_INFORMATION2
, 'HU_PENSION_SCHEME_INFO'
, EEI_INFORMATION2
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_NL_SAVINGS_DEDUCTIONS'
, EEI_INFORMATION2
, 'PQP_NL_PRE_TAX_DEDUCTIONS'
, EEI_INFORMATION2
, 'PQP_NL_PGGM_DEDUCTION'
, EEI_INFORMATION2
, 'PQP_NL_ABP_DEDUCTION'
, EEI_INFORMATION2
, 'PQP_GB_PENSION_SCHEME_INFO'
, EEI_INFORMATION3
, 'HU_PENSION_SCHEME_INFO'
, EEI_INFORMATION3
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_NL_SAVINGS_DEDUCTIONS'
, EEI_INFORMATION4
, 'PQP_NL_PRE_TAX_DEDUCTIONS'
, EEI_INFORMATION4
, 'PQP_NL_ABP_DEDUCTION'
, EEI_INFORMATION4
, 'PQP_GB_PENSION_SCHEME_INFO'
, EEI_INFORMATION4
, 'HU_PENSION_SCHEME_INFO'
, EEI_INFORMATION4
, NULL))
, EEI_INFORMATION5
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_PENSION_SCHEME_INFO'
, EEI_INFORMATION6
, 'HU_PENSION_SCHEME_INFO'
, EEI_INFORMATION6
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_PENSION_SCHEME_INFO'
, EEI_INFORMATION7
, 'HU_PENSION_SCHEME_INFO'
, EEI_INFORMATION7
, NULL))
, EEI_INFORMATION8
, EEI_INFORMATION9
, EEI_INFORMATION10
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_PENSION_SCHEME_INFO'
, EEI_INFORMATION11
, 'HU_PENSION_SCHEME_INFO'
, EEI_INFORMATION11
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_NL_SAVINGS_DEDUCTIONS'
, EEI_INFORMATION10
, 'PQP_NL_PRE_TAX_DEDUCTIONS'
, EEI_INFORMATION10
, 'PQP_NL_PGGM_DEDUCTION'
, EEI_INFORMATION4
, 'PQP_NL_ABP_DEDUCTION'
, EEI_INFORMATION9
, 'PQP_GB_PENSION_SCHEME_INFO'
, EEI_INFORMATION18
, 'HU_PENSION_SCHEME_INFO'
, EEI_INFORMATION12
, NULL))
, EEI_INFORMATION13
, EEI_INFORMATION1
, EEI_INFORMATION2
, EEI_INFORMATION3
, EEI_INFORMATION4
, EEI_INFORMATION5
, EEI_INFORMATION6
, EEI_INFORMATION7
, EEI_INFORMATION8
, EEI_INFORMATION1
, EEI_INFORMATION1
, EEI_INFORMATION2
, EEI_INFORMATION1
, (DECODE (EEI_INFORMATION_CATEGORY
, 'NO_EOY_REPORTING_CODE_MAPPING'
, EEI_INFORMATION4
, 'NO_EMPLOYEE_DEDUCTION_REPORT'
, EEI_INFORMATION2
, NULL))
, EEI_INFORMATION3
, EEI_INFORMATION4
, EEI_INFORMATION5
, (DECODE (EEI_INFORMATION_CATEGORY
, 'NO_EOY_REPORTING_CODE_MAPPING'
, FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION1)
, NULL))
, EEI_INFORMATION2
, EEI_INFORMATION3
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
, EEI_INFORMATION19
, 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
, EEI_INFORMATION19
, 'NO_EOY_REPORTING_CODE_MAPPING'
, EEI_INFORMATION17
, NULL))
, EEI_INFORMATION5
, EEI_INFORMATION6
, EEI_INFORMATION7
, EEI_INFORMATION8
, EEI_INFORMATION9
, EEI_INFORMATION10
, EEI_INFORMATION11
, EEI_INFORMATION12
, EEI_INFORMATION13
, EEI_INFORMATION14
, EEI_INFORMATION15
, EEI_INFORMATION16
, EEI_INFORMATION1
, EEI_INFORMATION2
, EEI_INFORMATION3
, EEI_INFORMATION4
, EEI_INFORMATION5
, EEI_INFORMATION1
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PAY_IN_BONUS_INFO_DFF'
, FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION2)
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PAY_US_TAX_CALCULATION_METHOD'
, EEI_INFORMATION3
, 'PAY_US_GARN_PROCESSING_RULE'
, EEI_INFORMATION10
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PAY_US_TAX_CALCULATION_METHOD'
, EEI_INFORMATION4
, 'PAY_US_GARN_PROCESSING_RULE'
, EEI_INFORMATION11
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PAY_US_GARN_PROCESSING_RULE'
, FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION12)
, NULL))
, EEI_INFORMATION13
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PAY_US_GARN_PROCESSING_RULE'
, FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION14)
, NULL))
, EEI_INFORMATION1
, EEI_INFORMATION4
, EEI_INFORMATION6
, EEI_INFORMATION2
, EEI_INFORMATION5
, EEI_INFORMATION1
, EEI_INFORMATION2
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
, EEI_INFORMATION1
, 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
, EEI_INFORMATION1
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
, EEI_INFORMATION2
, 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
, EEI_INFORMATION2
, NULL))
, EEI_INFORMATION3
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION4)
, NULL))
, EEI_INFORMATION5
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION6)
, NULL))
, EEI_INFORMATION7
, EEI_INFORMATION8
, EEI_INFORMATION9
, EEI_INFORMATION11
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
, EEI_INFORMATION10
, 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
, EEI_INFORMATION12
, NULL))
, EEI_INFORMATION13
, EEI_INFORMATION14
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION15)
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
, EEI_INFORMATION15
, 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
, EEI_INFORMATION16
, NULL))
, EEI_INFORMATION17
, EEI_INFORMATION18
, EEI_INFORMATION20
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
, EEI_INFORMATION27
, 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
, EEI_INFORMATION27
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
, EEI_INFORMATION28
, 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
, EEI_INFORMATION28
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
, EEI_INFORMATION29
, 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
, EEI_INFORMATION29
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
, EEI_INFORMATION30
, 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
, EEI_INFORMATION30
, NULL))
, EEI_INFORMATION3
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION4)
, NULL))
, EEI_INFORMATION5
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
, TO_DATE(EEI_INFORMATION6
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
, TO_DATE(EEI_INFORMATION7
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, EEI_INFORMATION8
, EEI_INFORMATION9
, EEI_INFORMATION11
, EEI_INFORMATION12
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION13)
, NULL))
, EEI_INFORMATION16
, EEI_INFORMATION17
, EEI_INFORMATION18
, EEI_INFORMATION26
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION20)
, NULL))
, EEI_INFORMATION21
, EEI_INFORMATION22
, EEI_INFORMATION23
, EEI_INFORMATION24
, EEI_INFORMATION14
, EEI_INFORMATION25
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_PENSERV_BONUS_INFO'
, EEI_INFORMATION1
, 'PQP_GB_PENSERV_ALLOWANCE_INFO'
, EEI_INFORMATION1
, NULL))
, EEI_INFORMATION2
, EEI_INFORMATION3
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_PENSERV_BONUS_INFO'
, EEI_INFORMATION4
, 'PQP_GB_PENSERV_ALLOWANCE_INFO'
, EEI_INFORMATION4
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_PENSERV_BONUS_INFO'
, EEI_INFORMATION5
, 'PQP_GB_PENSERV_ALLOWANCE_INFO'
, EEI_INFORMATION5
, NULL))
, EEI_INFORMATION6
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_PENSERV_BONUS_INFO'
, EEI_INFORMATION6
, 'PQP_GB_PENSERV_ALLOWANCE_INFO'
, EEI_INFORMATION7
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_PENSERV_BONUS_INFO'
, EEI_INFORMATION7
, 'PQP_GB_PENSERV_ALLOWANCE_INFO'
, EEI_INFORMATION8
, NULL))
, EEI_INFORMATION2
, EEI_INFORMATION3
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_GB_PENSION_SCHEME_INFO'
, TO_DATE(EEI_INFORMATION5
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_NL_SAVINGS_DEDUCTIONS'
, EEI_INFORMATION11
, 'PQP_GB_PENSION_SCHEME_INFO'
, EEI_INFORMATION8
, NULL))
, EEI_INFORMATION9
, EEI_INFORMATION19
, EEI_INFORMATION10
, EEI_INFORMATION12
, EEI_INFORMATION13
, EEI_INFORMATION14
, EEI_INFORMATION15
, EEI_INFORMATION20
, EEI_INFORMATION16
, EEI_INFORMATION17
, EEI_INFORMATION21
, EEI_INFORMATION22
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_NL_SAVINGS_DEDUCTIONS'
, EEI_INFORMATION5
, 'PQP_NL_PRE_TAX_DEDUCTIONS'
, EEI_INFORMATION5
, 'PQP_NL_ABP_DEDUCTION'
, EEI_INFORMATION5
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_NL_SAVINGS_DEDUCTIONS'
, EEI_INFORMATION6
, 'PQP_NL_PRE_TAX_DEDUCTIONS'
, EEI_INFORMATION6
, 'PQP_NL_ABP_DEDUCTION'
, EEI_INFORMATION6
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_NL_SAVINGS_DEDUCTIONS'
, EEI_INFORMATION7
, 'PQP_NL_PRE_TAX_DEDUCTIONS'
, EEI_INFORMATION7
, 'PQP_NL_ABP_DEDUCTION'
, EEI_INFORMATION7
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_NL_SAVINGS_DEDUCTIONS'
, EEI_INFORMATION8
, 'PQP_NL_PRE_TAX_DEDUCTIONS'
, EEI_INFORMATION8
, 'PQP_NL_ABP_DEDUCTION'
, EEI_INFORMATION8
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_NL_PGGM_DEDUCTION'
, EEI_INFORMATION5
, 'PQP_NL_ABP_DEDUCTION'
, EEI_INFORMATION10
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_NL_PGGM_DEDUCTION'
, EEI_INFORMATION6
, 'PQP_NL_ABP_DEDUCTION'
, EEI_INFORMATION11
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_NL_PGGM_DEDUCTION'
, EEI_INFORMATION7
, 'PQP_NL_ABP_DEDUCTION'
, EEI_INFORMATION12
, NULL))
, EEI_INFORMATION13
, EEI_INFORMATION14
, EEI_INFORMATION15
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_NL_PGGM_DEDUCTION'
, EEI_INFORMATION8
, 'PQP_NL_ABP_DEDUCTION'
, EEI_INFORMATION16
, NULL))
, EEI_INFORMATION17
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_NL_PGGM_DEDUCTION'
, EEI_INFORMATION11
, 'PQP_NL_ABP_DEDUCTION'
, EEI_INFORMATION18
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_NL_PGGM_DEDUCTION'
, EEI_INFORMATION12
, 'PQP_NL_ABP_DEDUCTION'
, EEI_INFORMATION19
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_NL_PGGM_DEDUCTION'
, EEI_INFORMATION13
, 'PQP_NL_ABP_DEDUCTION'
, EEI_INFORMATION20
, NULL))
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_NL_PGGM_DEDUCTION'
, EEI_INFORMATION14
, 'PQP_NL_ABP_DEDUCTION'
, EEI_INFORMATION21
, NULL))
, EEI_INFORMATION9
, EEI_INFORMATION10
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_NL_SAVINGS_DEDUCTIONS'
, EEI_INFORMATION9
, 'PQP_NL_PRE_TAX_DEDUCTIONS'
, EEI_INFORMATION9
, NULL))
, EEI_INFORMATION1
, EEI_INFORMATION1
, EEI_INFORMATION2
, EEI_INFORMATION3
, EEI_INFORMATION4
, EEI_INFORMATION1
, EEI_INFORMATION2
, EEI_INFORMATION3
, EEI_INFORMATION4
, EEI_INFORMATION5
, EEI_INFORMATION6
, EEI_INFORMATION7
, (DECODE (EEI_INFORMATION_CATEGORY
, 'PQP_UK_ELEMENT_ATTRIBUTION'
, FND_NUMBER.CANONICAL_TO_NUMBER(EEI_INFORMATION8)
, NULL))
, EEI_INFORMATION9
, EEI_INFORMATION11
, EEI_INFORMATION10
, EEI_INFORMATION12
, EEI_INFORMATION13
, EEI_INFORMATION14
, EEI_INFORMATION15
, EEI_INFORMATION16
, EEI_INFORMATION17
, EEI_INFORMATION18
, EEI_INFORMATION19
, EEI_INFORMATION1
, EEI_INFORMATION2
, EEI_INFORMATION1
, EEI_INFORMATION2
, EEI_INFORMATION3
, EEI_INFORMATION4
, EEI_INFORMATION3
, EEI_INFORMATION4
, EEI_INFORMATION5
, EEI_INFORMATION1
, EEI_INFORMATION2
, EEI_INFORMATION3
, EEI_INFORMATION10
, EEI_INFORMATION3
, EEI_INFORMATION1
, EEI_INFORMATION2
, (DECODE (EEI_INFORMATION_CATEGORY
, 'AU_RETRO_UPGRADE_INFO'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1
, 'DEDUCTION_PROCESSING'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1
, 'HU_PENSION_SCHEME_INFO'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8 || '.' || EEI_INFORMATION9 || '.' || EEI_INFORMATION10 || '.' || EEI_INFORMATION11 || '.' || EEI_INFORMATION12 || '.' || EEI_INFORMATION13
, 'IE_PENSION_SCHEME_INFO'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8
, 'MX_DEDUCTION_PROCESSING'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1
, 'NO_ELEMENT_CODES'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2
, 'NO_EMPLOYEE_DEDUCTION_REPORT'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5
, 'NO_EOY_REPORTING_CODE_MAPPING'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION17 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8 || '.' || EEI_INFORMATION9 || '.' || EEI_INFORMATION10 || '.' || EEI_INFORMATION11 || '.' || EEI_INFORMATION12 || '.' || EEI_INFORMATION13 || '.' || EEI_INFORMATION14 || '.' || EEI_INFORMATION15 || '.' || EEI_INFORMATION16
, 'NO_SSB_CODES'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5
, 'PAY_IN_BONUS_INFO_DFF'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2
, 'PAY_US_GARN_PROCESSING_RULE'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION10 || '.' || EEI_INFORMATION11 || '.' || EEI_INFORMATION12 || '.' || EEI_INFORMATION13 || '.' || EEI_INFORMATION14
, 'PAY_US_INFORMATION_TIME'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1
, 'PAY_US_ROTH_OPTIONS'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION6
, 'PAY_US_TAX_CALCULATION_METHOD'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5
, 'PQP_GB_ARREARAGE_INFO'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2
, 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8 || '.' || EEI_INFORMATION9 || '.' || EEI_INFORMATION11 || '.' || EEI_INFORMATION12 || '.' || EEI_INFORMATION13 || '.' || EEI_INFORMATION14 || '.' || EEI_INFORMATION15 || '.' || EEI_INFORMATION16 || '.' || EEI_INFORMATION17 || '.' || EEI_INFORMATION18 || '.' || EEI_INFORMATION19 || '.' || EEI_INFORMATION20 || '.' || EEI_INFORMATION27 || '.' || EEI_INFORMATION28 || '.' || EEI_INFORMATION29 || '.' || EEI_INFORMATION30
, 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8 || '.' || EEI_INFORMATION9 || '.' || EEI_INFORMATION10 || '.' || EEI_INFORMATION11 || '.' || EEI_INFORMATION12 || '.' || EEI_INFORMATION13 || '.' || EEI_INFORMATION19 || '.' || EEI_INFORMATION15 || '.' || EEI_INFORMATION16 || '.' || EEI_INFORMATION17 || '.' || EEI_INFORMATION18 || '.' || EEI_INFORMATION30 || '.' || EEI_INFORMATION29 || '.' || EEI_INFORMATION28 || '.' || EEI_INFORMATION27 || '.' || EEI_INFORMATION26 || '.' || EEI_INFORMATION20 || '.' || EEI_INFORMATION21 || '.' || EEI_INFORMATION22 || '.' || EEI_INFORMATION23 || '.' || EEI_INFORMATION24 || '.' || EEI_INFORMATION14 || '.' || EEI_INFORMATION25
, 'PQP_GB_PENSERV_ALLOWANCE_INFO'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8
, 'PQP_GB_PENSERV_BONUS_INFO'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7
, 'PQP_GB_PENSION_SCHEME_INFO'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8 || '.' || EEI_INFORMATION9 || '.' || EEI_INFORMATION19 || '.' || EEI_INFORMATION10 || '.' || EEI_INFORMATION11 || '.' || EEI_INFORMATION12 || '.' || EEI_INFORMATION13 || '.' || EEI_INFORMATION14 || '.' || EEI_INFORMATION15 || '.' || EEI_INFORMATION20 || '.' || EEI_INFORMATION16 || '.' || EEI_INFORMATION17 || '.' || EEI_INFORMATION18 || '.' || EEI_INFORMATION21 || '.' || EEI_INFORMATION22
, 'PQP_NL_ABP_DEDUCTION'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8 || '.' || EEI_INFORMATION9 || '.' || EEI_INFORMATION10 || '.' || EEI_INFORMATION11 || '.' || EEI_INFORMATION12 || '.' || EEI_INFORMATION13 || '.' || EEI_INFORMATION14 || '.' || EEI_INFORMATION15 || '.' || EEI_INFORMATION16 || '.' || EEI_INFORMATION17 || '.' || EEI_INFORMATION18 || '.' || EEI_INFORMATION19 || '.' || EEI_INFORMATION20 || '.' || EEI_INFORMATION21
, 'PQP_NL_PGGM_DEDUCTION'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8 || '.' || EEI_INFORMATION9 || '.' || EEI_INFORMATION10 || '.' || EEI_INFORMATION11 || '.' || EEI_INFORMATION12 || '.' || EEI_INFORMATION13 || '.' || EEI_INFORMATION14
, 'PQP_NL_PRE_TAX_DEDUCTIONS'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8 || '.' || EEI_INFORMATION9 || '.' || EEI_INFORMATION10
, 'PQP_NL_SAVINGS_DEDUCTIONS'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8 || '.' || EEI_INFORMATION9 || '.' || EEI_INFORMATION10 || '.' || EEI_INFORMATION11
, 'PQP_PROFESSIONAL_BODY_INFO'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4
, 'PQP_UK_ELEMENT_ATTRIBUTION'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5 || '.' || EEI_INFORMATION6 || '.' || EEI_INFORMATION7 || '.' || EEI_INFORMATION8 || '.' || EEI_INFORMATION9 || '.' || EEI_INFORMATION11 || '.' || EEI_INFORMATION10 || '.' || EEI_INFORMATION12 || '.' || EEI_INFORMATION13 || '.' || EEI_INFORMATION14 || '.' || EEI_INFORMATION15 || '.' || EEI_INFORMATION16 || '.' || EEI_INFORMATION17 || '.' || EEI_INFORMATION18 || '.' || EEI_INFORMATION19
, 'PQP_UK_RATE_TYPE'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2
, 'PQP_UK_UNION_INFO'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION4
, 'PQP_US_PRE_TAX_DEDUCTIONS'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION3
, 'PQP_US_SRS_DEDUCTIONS'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION4 || '.' || EEI_INFORMATION5
, 'PQP_VEHICLE_MILEAGE_INFO'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2 || '.' || EEI_INFORMATION3
, 'US_EARNINGS'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION10
, 'US_TIAA_CREF_CONT_TYPES'
, EEI_INFORMATION_CATEGORY || '.' || EEI_INFORMATION3 || '.' || EEI_INFORMATION1 || '.' || EEI_INFORMATION2
, NULL))
FROM PAY_ELEMENT_TYPE_EXTRA_INFO