VIEW: APPS.PAY_JP_EMP_V

Source

View Text - Preformatted

SELECT pa.rowid,pa.assignment_id, pa.assignment_type,pa.payroll_id, pp.person_id,ppt.system_person_type, pp.current_applicant_flag,pp.current_employee_flag, pp.current_emp_or_apl_flag,pa.business_group_id, pp.employee_number,pp.applicant_number, pp.full_name,pp.global_name,pp.local_name,pa.assignment_number, pp.date_of_birth,trunc(months_between(fnd.effective_date,pp.date_of_birth)/12), pa.primary_flag from per_person_types ppt,per_all_people_f pp, per_assignments_f2 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 pa.assignment_type='E' 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
, PA.ASSIGNMENT_ID
, PA.ASSIGNMENT_TYPE
, PA.PAYROLL_ID
, PP.PERSON_ID
, PPT.SYSTEM_PERSON_TYPE
, PP.CURRENT_APPLICANT_FLAG
, PP.CURRENT_EMPLOYEE_FLAG
, PP.CURRENT_EMP_OR_APL_FLAG
, PA.BUSINESS_GROUP_ID
, PP.EMPLOYEE_NUMBER
, PP.APPLICANT_NUMBER
, PP.FULL_NAME
, PP.GLOBAL_NAME
, PP.LOCAL_NAME
, PA.ASSIGNMENT_NUMBER
, PP.DATE_OF_BIRTH
, TRUNC(MONTHS_BETWEEN(FND.EFFECTIVE_DATE
, PP.DATE_OF_BIRTH)/12)
, PA.PRIMARY_FLAG
FROM PER_PERSON_TYPES PPT
, PER_ALL_PEOPLE_F PP
, PER_ASSIGNMENTS_F2 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 PA.ASSIGNMENT_TYPE='E'
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