VIEW: APPS.PAY_KR_NP_ADJ_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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