View: PAY_KR_NP_ADJ_V

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

View Text

SELECT PEI.INFORMATION_TYPE INFORMATION_TYPE
, PAP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PEI.PERSON_ID PERSON_ID
, PAA.ESTABLISHMENT_ID BUSINESS_PLACE_ID
, PAP.LAST_NAME||PAP.FIRST_NAME EMPLOYEE_NAME
, PAP.NATIONAL_IDENTIFIER EMPLOYEE_NI
, PAP.EFFECTIVE_START_DATE PERSON_START_DATE
, PAP.EFFECTIVE_END_DATE PERSON_END_DATE
, PAA.EFFECTIVE_START_DATE ASG_START_DATE
, PAA.EFFECTIVE_END_DATE ASG_END_DATE
, TO_NUMBER(PEI.PEI_INFORMATION1) MONTHLY_EARNINGS
, PEI.PEI_INFORMATION2 REQUISITION_CODE
, FND_DATE.CANONICAL_TO_DATE(PEI.PEI_INFORMATION3) REQUISITION_START_DATE
, PEI.PEI_INFORMATION4 SPECIAL_JOB_CODE
, FND_DATE.CANONICAL_TO_DATE(PEI.PEI_INFORMATION6) LOSS_START_DATE
, PEI.PEI_INFORMATION5 LOSS_CODE
, PEI.PEI_INFORMATION7 NP_REPORTED
, PAA.ASSIGNMENT_ID ASSIGNMENT_ID
, PPS.ACTUAL_TERMINATION_DATE TERMINATION_DATE
FROM PER_PEOPLE_F PAP
, PER_PEOPLE_EXTRA_INFO PEI
, PER_ASSIGNMENTS_F PAA
, PER_PERIODS_OF_SERVICE PPS
WHERE PEI.INFORMATION_TYPE = 'PER_KR_NATIONAL_PENSION_INFO'
AND PAP.BUSINESS_GROUP_ID = PAA.BUSINESS_GROUP_ID
AND PAA.PERSON_ID = PAP.PERSON_ID
AND PEI.PERSON_ID = PAP.PERSON_ID
AND PPS.PERSON_ID = PAP.PERSON_ID

Columns