VIEW: APPS.PAY_KR_EMP_DETAILS_V

Source

View Text - Preformatted

SELECT paa.establishment_id emp_establishment_id ,paa.assignment_id emp_assignment_id ,pap.person_id emp_person_id ,pap.full_name emp_full_name ,pap.national_identifier emp_ni_number ,pap.date_of_birth emp_date_of_birth ,pap.sex emp_sex ,paa.effective_start_date emp_start_date ,paa.effective_end_date emp_end_date ,pap.effective_start_date person_start_date ,pap.effective_end_date person_end_date ,hoi.org_information2 company_reg_num ,hoi.org_information10 company_name from per_people_f pap ,per_assignments_f paa ,hr_organization_information hoi WHERE pap.person_id = paa.person_id and paa.payroll_id is not null and hoi.organization_id = paa.establishment_id and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'

View Text - HTML Formatted

SELECT PAA.ESTABLISHMENT_ID EMP_ESTABLISHMENT_ID
, PAA.ASSIGNMENT_ID EMP_ASSIGNMENT_ID
, PAP.PERSON_ID EMP_PERSON_ID
, PAP.FULL_NAME EMP_FULL_NAME
, PAP.NATIONAL_IDENTIFIER EMP_NI_NUMBER
, PAP.DATE_OF_BIRTH EMP_DATE_OF_BIRTH
, PAP.SEX EMP_SEX
, PAA.EFFECTIVE_START_DATE EMP_START_DATE
, PAA.EFFECTIVE_END_DATE EMP_END_DATE
, PAP.EFFECTIVE_START_DATE PERSON_START_DATE
, PAP.EFFECTIVE_END_DATE PERSON_END_DATE
, HOI.ORG_INFORMATION2 COMPANY_REG_NUM
, HOI.ORG_INFORMATION10 COMPANY_NAME
FROM PER_PEOPLE_F PAP
, PER_ASSIGNMENTS_F PAA
, HR_ORGANIZATION_INFORMATION HOI
WHERE PAP.PERSON_ID = PAA.PERSON_ID
AND PAA.PAYROLL_ID IS NOT NULL
AND HOI.ORGANIZATION_ID = PAA.ESTABLISHMENT_ID
AND HOI.ORG_INFORMATION_CONTEXT = 'KR_BUSINESS_PLACE_REGISTRATION'