View: PAY_KR_PREV_ER_V

Product:	PAY - Payroll
Description:	This view returns EIT value of 'KR_YEA_PREV_ER_INFO' based on assignment_id.
Implementation/DBA Data:	APPS.PAY_KR_PREV_ER_V

View Text

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) TERMINATION_DATE
, AEI.AEI_INFORMATION2 BP_NAME
, AEI.AEI_INFORMATION3 BP_NUMBER
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION4) TAXABLE_EARNINGS_MTH
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION5) TAXABLE_EARNINGS_BON
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION6) SP_IRREG_BONUS
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION7) NON_TAXABLE_OVS_EARNINGS
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION8) NON_TAXABLE_OVT_EARNINGS
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION9) NON_TAXABLE_OTH_EARNINGS
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION10) HI_PREM
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION11) EI_PREM
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION12) NP_PREM
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION13) ITAX
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION14) RTAX
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION15) STAX
FROM PER_ASSIGNMENT_EXTRA_INFO AEI
, FND_SESSIONS FND
WHERE AEI.INFORMATION_TYPE = 'KR_YEA_PREV_ER_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)

Columns