VIEW: APPS.PAY_JP_PRE_TAX

Source

View Text - Preformatted

SELECT /*+ ORDERED USE_NL(PAI, PAI1) INDEX(PAI PAY_ACTION_INFORMATION_N3) INDEX(PAI1 PAY_ACTION_INFORMATION_N3) */ pai.rowid, pai.action_information_id pre_tax_id, 1 action_id, fnd_number.canonical_to_number(pai.action_information1) assignment_action_id, pai.action_information1 assignment_action_id_perf, 'C' action_status, pai.action_information13 salary_category, fnd_number.canonical_to_number(pai.action_information2) taxable_sal_amt, fnd_number.canonical_to_number(pai.action_information3) taxable_mat_amt, fnd_number.canonical_to_number(pai1.action_information13) previous_taxable_amt, fnd_number.canonical_to_number(pai.action_information5) hi_organization_id, fnd_number.canonical_to_number(pai.action_information6) hi_prem_ee, fnd_number.canonical_to_number(pai.action_information7) hi_prem_er, fnd_number.canonical_to_number(pai.action_information8) wp_organization_id, fnd_number.canonical_to_number(pai.action_information9) wp_prem_ee, fnd_number.canonical_to_number(pai.action_information10) wp_prem_er, fnd_number.canonical_to_number(pai.action_information11) wpf_organization_id, fnd_number.canonical_to_number(pai.action_information12) wpf_prem_ee, fnd_number.canonical_to_number(pai1.action_information20) wpf_prem_er, fnd_number.canonical_to_number(pai.action_information19) ui_organization_id, pai1.action_information14 ui_category, fnd_number.canonical_to_number(pai.action_information20) ui_prem_ee, fnd_number.canonical_to_number(pai1.action_information16) ui_sal_amt, fnd_number.canonical_to_number(pai1.action_information17) wai_organization_id, pai1.action_information18 wai_category, fnd_number.canonical_to_number(pai1.action_information19) wai_sal_amt, fnd_number.canonical_to_number(pai.action_information21) itax_organization_id, pai.action_information22 itax_category, pai.action_information23 itax_yea_category, fnd_number.canonical_to_number(pai.action_information24) itax, fnd_number.canonical_to_number(pai.action_information25) itax_adjustment, fnd_number.canonical_to_number(pai1.action_information21) previous_itax, fnd_number.canonical_to_number(pai1.action_information2) ltax_organization_id, pai1.action_information3 ltax_district_code, pai1.action_information4 ltax_swot_no, fnd_number.canonical_to_number(pai1.action_information5) ltax, fnd_number.canonical_to_number(pai1.action_information6) ltax_lumpsum, fnd_number.canonical_to_number(pai1.action_information7) sp_ltax, fnd_number.canonical_to_number(pai1.action_information8) sp_ltax_income, fnd_number.canonical_to_number(pai1.action_information9) sp_ltax_shi, fnd_number.canonical_to_number(pai1.action_information10) sp_ltax_to, fnd_number.canonical_to_number(pai1.action_information11) ci_prem_ee, fnd_number.canonical_to_number(pai1.action_information12) ci_prem_er, fnd_number.canonical_to_number(pai.action_information14) mutual_aid, fnd_number.canonical_to_number(pai.action_information29) disaster_tax_reduction, pai1.action_information15 sp_ltax_district_code from pay_action_information pai, pay_action_information pai1 where pai.action_information_category='JP_PRE_TAX_1' and pai.action_context_type='AAP' and pai1.action_information_category='JP_PRE_TAX_2' and pai1.action_context_type=pai.action_context_type and pai1.action_information1=pai.action_information1

View Text - HTML Formatted

SELECT /*+ ORDERED USE_NL(PAI
, PAI1) INDEX(PAI PAY_ACTION_INFORMATION_N3) INDEX(PAI1 PAY_ACTION_INFORMATION_N3) */ PAI.ROWID
, PAI.ACTION_INFORMATION_ID PRE_TAX_ID
, 1 ACTION_ID
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION1) ASSIGNMENT_ACTION_ID
, PAI.ACTION_INFORMATION1 ASSIGNMENT_ACTION_ID_PERF
, 'C' ACTION_STATUS
, PAI.ACTION_INFORMATION13 SALARY_CATEGORY
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION2) TAXABLE_SAL_AMT
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION3) TAXABLE_MAT_AMT
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI1.ACTION_INFORMATION13) PREVIOUS_TAXABLE_AMT
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION5) HI_ORGANIZATION_ID
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION6) HI_PREM_EE
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION7) HI_PREM_ER
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION8) WP_ORGANIZATION_ID
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION9) WP_PREM_EE
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION10) WP_PREM_ER
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION11) WPF_ORGANIZATION_ID
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION12) WPF_PREM_EE
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI1.ACTION_INFORMATION20) WPF_PREM_ER
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION19) UI_ORGANIZATION_ID
, PAI1.ACTION_INFORMATION14 UI_CATEGORY
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION20) UI_PREM_EE
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI1.ACTION_INFORMATION16) UI_SAL_AMT
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI1.ACTION_INFORMATION17) WAI_ORGANIZATION_ID
, PAI1.ACTION_INFORMATION18 WAI_CATEGORY
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI1.ACTION_INFORMATION19) WAI_SAL_AMT
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION21) ITAX_ORGANIZATION_ID
, PAI.ACTION_INFORMATION22 ITAX_CATEGORY
, PAI.ACTION_INFORMATION23 ITAX_YEA_CATEGORY
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION24) ITAX
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION25) ITAX_ADJUSTMENT
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI1.ACTION_INFORMATION21) PREVIOUS_ITAX
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI1.ACTION_INFORMATION2) LTAX_ORGANIZATION_ID
, PAI1.ACTION_INFORMATION3 LTAX_DISTRICT_CODE
, PAI1.ACTION_INFORMATION4 LTAX_SWOT_NO
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI1.ACTION_INFORMATION5) LTAX
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI1.ACTION_INFORMATION6) LTAX_LUMPSUM
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI1.ACTION_INFORMATION7) SP_LTAX
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI1.ACTION_INFORMATION8) SP_LTAX_INCOME
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI1.ACTION_INFORMATION9) SP_LTAX_SHI
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI1.ACTION_INFORMATION10) SP_LTAX_TO
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI1.ACTION_INFORMATION11) CI_PREM_EE
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI1.ACTION_INFORMATION12) CI_PREM_ER
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION14) MUTUAL_AID
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION29) DISASTER_TAX_REDUCTION
, PAI1.ACTION_INFORMATION15 SP_LTAX_DISTRICT_CODE
FROM PAY_ACTION_INFORMATION PAI
, PAY_ACTION_INFORMATION PAI1
WHERE PAI.ACTION_INFORMATION_CATEGORY='JP_PRE_TAX_1'
AND PAI.ACTION_CONTEXT_TYPE='AAP'
AND PAI1.ACTION_INFORMATION_CATEGORY='JP_PRE_TAX_2'
AND PAI1.ACTION_CONTEXT_TYPE=PAI.ACTION_CONTEXT_TYPE
AND PAI1.ACTION_INFORMATION1=PAI.ACTION_INFORMATION1