140: --
141: l_dummy varchar2(240);
142: cursor c_person_name is
143: select full_name
144: from per_all_people_f
145: where person_id = p_person_id
146: AND SYSDATE BETWEEN effective_start_date AND effective_end_date;
147: --
148: begin
303: l_description varchar2(500);
304:
305: cursor csr_future_person_rec is
306: SELECT ppf.full_name
307: FROM per_all_people_f ppf
308: WHERE ppf.person_id = pPersonId and
309: ppf.effective_end_date > To_Date('30-12-4712','dd-mm-yyyy') and
310: ppf.current_employee_flag IS null;
311: --