View: PAY_JP_PRE_TAX

Product:	PAY - Payroll
Description:	This view contains Japanese legislative reports data.
Implementation/DBA Data:	APPS.PAY_JP_PRE_TAX

View Text

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

Columns