Product: | PAY - Payroll |
---|---|
Description: | This view returns employee information based on session_date. |
Implementation/DBA Data: | APPS.PAY_KR_EMP_V |
SELECT PA.ROWID ROW_ID
, PA.ASSIGNMENT_ID ASSIGNMENT_ID
, PA.ASSIGNMENT_TYPE ASSIGNMENT_TYPE
, PA.PAYROLL_ID PAYROLL_ID
, PA.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PA.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, HOUTL.NAME BUSINESS_PLACE_NAME
, PP.PERSON_ID PERSON_ID
, PPT.SYSTEM_PERSON_TYPE SYSTEM_PERSON_TYPE
, PP.CURRENT_APPLICANT_FLAG CURRENT_APPLICANT_FLAG
, PP.CURRENT_EMPLOYEE_FLAG CURRENT_EMPLOYEE_FLAG
, PP.CURRENT_EMP_OR_APL_FLAG CURRENT_EMP_OR_APL_FLAG
, PP.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PP.APPLICANT_NUMBER APPLICANT_NUMBER
, PP.FULL_NAME FULL_NAME
, PP.NATIONAL_IDENTIFIER NATIONAL_IDENTIFIER
, PAY_KR_FF_FUNCTIONS_PKG.NI_DATE_OF_BIRTH(PP.NATIONAL_IDENTIFIER) DATE_OF_BIRTH
, PP.SEX SEX
, PP.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, PP.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, TO_NUMBER(TO_CHAR(FND.EFFECTIVE_DATE
, 'YYYY')) - TO_NUMBER(TO_CHAR(PAY_KR_FF_FUNCTIONS_PKG.NI_DATE_OF_BIRTH(PP.NATIONAL_IDENTIFIER)
, 'YYYY')) AGE
FROM PER_PERSON_TYPES PPT
, PER_PEOPLE_F PP
, HR_ALL_ORGANIZATION_UNITS_TL HOUTL
, HR_ORGANIZATION_UNITS HOU
, PER_ASSIGNMENTS_F PA
, FND_SESSIONS FND
WHERE FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN PA.EFFECTIVE_START_DATE
AND PA.EFFECTIVE_END_DATE
AND HOU.ORGANIZATION_ID(+) = PA.ESTABLISHMENT_ID
AND HOUTL.ORGANIZATION_ID(+) = HOU.ORGANIZATION_ID
AND HOUTL.LANGUAGE(+) = USERENV('LANG')
AND PP.PERSON_ID = PA.PERSON_ID
AND FND.EFFECTIVE_DATE BETWEEN PP.EFFECTIVE_START_DATE
AND PP.EFFECTIVE_END_DATE
AND PPT.PERSON_TYPE_ID = PP.PERSON_TYPE_ID