167:
168: cursor c_exemp is
169: select ppf.effective_start_date effective_start_date
170: from per_people_f ppf,
171: per_person_types ppt
172: where ppf.person_id = p_pa_requests_type.person_id
173: and ppf.person_type_id = ppt.person_type_id
174: and ppt.SYSTEM_PERSON_TYPE = 'EX_EMP'
175: and ppf.effective_start_date > p_pa_requests_type.effective_date;
757: cursor cur_asg_end_date is
758: select ppf.effective_end_date effective_end_date,
759: ppt.system_person_type system_person_type
760: from per_people_f ppf,
761: per_person_types ppt
762: where ppf.person_id = l_person_id
763: and ppf.person_type_id = ppt.person_type_id
764: and ppf.effective_end_date >= p_rpa_eff_date
765: and ppt.SYSTEM_PERSON_TYPE > 'APL'