View: PAY_KR_PREV_EMPL_INFO_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_KR_PREV_EMPL_INFO_V

View Text

SELECT PAA.ASSIGNMENT_ID EMP_ID
, PAA.EFFECTIVE_START_DATE EMP_START_DATE
, PAA.EFFECTIVE_END_DATE EMP_END_DATE
, AEI.AEI_INFORMATION1 PREV_TERM_DATE
, AEI.AEI_INFORMATION2 PREV_BUS_PLC
, AEI.AEI_INFORMATION3 PREV_BUS_PLC_NUM
, NVL(AEI.AEI_INFORMATION4
, 0)+NVL(AEI.AEI_INFORMATION5
, 0)+NVL(AEI.AEI_INFORMATION6
, 0)+NVL(AEI.AEI_INFORMATION7
, 0) +NVL(AEI.AEI_INFORMATION8
, 0)+NVL(AEI.AEI_INFORMATION9
, 0) PREV_EARN
FROM PER_ASSIGNMENTS_F PAA
, PER_ASSIGNMENT_EXTRA_INFO AEI
WHERE PAA.ASSIGNMENT_ID = AEI.ASSIGNMENT_ID
AND AEI.INFORMATION_TYPE = 'KR_YEA_PREV_ER_INFO'

Columns