ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471E051A9E05362FB09050512Y SELECT hr.meaning Event_Review_Type, pe.date_start , pe.time_start FROM per_events pe, per_bookings pb, per_all_people_f pap, hr_lookups hr WHERE pe.event_id = pb.event_id AND pap.person_id = pb.person_id AND pe.type = hr.lookup_code AND hr.lookup_type = 'EMP_EVENT_TYPE' AND pe.event_or_interview = 'E' AND SYSDATE BETWEEN pap.effective_start_date and pap.effective_end_date AND pe.business_group_id+0 = :p_business_group_id AND pap.person_id = :p_person_id AND pe.date_start >= SYSDATE AND UPPER(hr.meaning) LIKE '%TENURE%' UNION SELECT hr.meaning, pe.date_start , pe.time_start FROM per_all_assignments_f paf, per_events pe, hr_lookups hr, per_all_people_f pap WHERE pe.assignment_id = paf.assignment_id AND pap.person_id = paf.person_id AND pe.type = hr.lookup_code AND SYSDATE BETWEEN paf.effective_start_date and paf.effective_end_date AND SYSDATE BETWEEN pap.effective_start_date and pap.effective_end_date AND pe.emp_or_apl = 'E' AND hr.lookup_type = 'EMP_INTERVIEW_TYPE' AND pe.event_or_interview = 'I' AND pap.person_id = :p_person_id AND pe.business_group_id +0 = :p_business_group_id AND pe.date_start >= SYSDATE PQH PQHUSUCE_XML US PQH Upcoming Events Imported from BI Publisher Description: Tenure: Upcoming Events Report Application: Public Sector HR Source: Tenure: Upcoming Events Report (XML) Short Name: PQHUSUCE_XML DB package: PQH_PQHUSUCE_XMLP_PKG BI Publisher :cp_academic_manager_name :cp_body_text :cp_business_group_name :cp_employee_id :cp_faculty_member_name :function_desc :p_business_group_id :p_conc_request_id :p_person_id 1 -30 :p_dummy Char 02 US PER_CHAR Tenure Status 2 -20 :p_business_group_id Char fnd_profile.value('PER_BUSINESS_GROUP_ID') US Business Group Id Business Group Id 3 10 :p_person_id LOV Oracle PQH_TENURE_PERSON Y select ppf.person_id id, ppf.full_name value, null description from per_people_f ppf,per_person_types ppt,per_people_extra_info pei where ppf.business_group_id+0= fnd_global.per_business_group_id and ppt.person_type_id=ppf.person_type_id+0 and pei.person_id=ppf.person_id and pei.pei_information_category='PQH_TENURE_STATUS' and ((:$flex$.per_char='**' and pei.pei_information1 is not null) or (:$flex$.per_char is not null and pei.pei_information1=:$flex$.per_char)) and ppt.system_person_type in ('EMP','EMP_APL','EX_EMP','EX_EMP_APL') and ppf.effective_start_date= (select max(effective_start_date) from per_people_f ppf1 where ppf1.person_id=ppf.person_id) order by ppf.last_name,ppf.first_name Y US Faculty Member Faculty Member