Product: | PAY - Payroll |
---|---|
Description: | This view returns EIT value of 'KR_YEA_SP_TAX_EXEM_INFO' based on assignment_id. |
Implementation/DBA Data: | APPS.PAY_KR_SP_TAX_EXEM_V |
SELECT AEI.ROWID ROW_ID
, AEI.ASSIGNMENT_EXTRA_INFO_ID
, AEI.ASSIGNMENT_ID
, AEI.INFORMATION_TYPE
, AEI.AEI_INFORMATION_CATEGORY
, AEI.OBJECT_VERSION_NUMBER
, FND_DATE.CANONICAL_TO_DATE(AEI.AEI_INFORMATION1) EFFECTIVE_DATE
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION2) HI_PREM
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION3) EI_PREM
, AEI.AEI_INFORMATION4 PERS_INS_NAME
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION5) PERS_INS_PREM
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION6) DISABLED_INS_PREM
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION7) MED_EXP
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION8) MED_EXP_DISABLED
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION9) MED_EXP_AGED
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION10) EE_EDUC_EXP
, AEI.AEI_INFORMATION11 HOUSING_SAVING_TYPE
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION12) HOUSING_SAVING
, FND_DATE.CANONICAL_TO_DATE(AEI.AEI_INFORMATION13) HOUSING_PURCHASE_DATE
, FND_DATE.CANONICAL_TO_DATE(AEI.AEI_INFORMATION14) HOUSING_LOAN_DATE
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION15) HOUSING_LOAN_REPAY
, FND_DATE.CANONICAL_TO_DATE(AEI.AEI_INFORMATION16) LT_HOUSING_LOAN_DATE
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION17) LT_HOUSING_LOAN_INTEREST_REPAY
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION18) DONATION1
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION19) POLITICAL_DONATION1
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION20) POLITICAL_DONATION2
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION21) POLITICAL_DONATION3
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION22) DONATION2
FROM PER_ASSIGNMENT_EXTRA_INFO AEI
, FND_SESSIONS FND
WHERE AEI.INFORMATION_TYPE = 'KR_YEA_SP_TAX_EXEM_INFO'
AND FND.SESSION_ID = USERENV('SESSIONID')
AND SUBSTR(TO_CHAR(FND.EFFECTIVE_DATE
, 'DD-MON-YYYY')
, 8
, 4) = SUBSTR(AEI.AEI_INFORMATION1
, 1
, 4)