Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAY_KR_EMP_DETAILS_V |
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'