APPS.PER_IREC_ICD_ENRLL_PROCESS dependencies on PER_ALL_PEOPLE_F

Line 100: from per_all_people_f

96: --
97: l_dummy varchar2(240);
98: cursor c_person_name is
99: select full_name
100: from per_all_people_f
101: where person_id = p_person_id
102: AND SYSDATE BETWEEN effective_start_date AND effective_end_date;
103: --
104: begin

Line 260: FROM per_all_people_f ppf

256: l_description varchar2(500);
257:
258: cursor csr_future_person_rec is
259: SELECT ppf.full_name
260: FROM per_all_people_f ppf
261: WHERE ppf.person_id = pPersonId and
262: ppf.effective_end_date > To_Date('30-12-4712','dd-mm-yyyy') and
263: ppf.current_employee_flag IS null;
264: --