VIEW: APPS.PAY_KR_EMP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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