APPS.GHR_GEN_RPA_NPA dependencies on PER_ALL_PEOPLE_F

Line 201: from per_all_people_f per1

197: AND pre.pa_request_id = c_pa_request_id;
198:
199: CURSOR c_person_name(p_person_id NUMBER, p_effective_date DATE) IS
200: SELECT per1.first_name||' '|| DECODE(per1.middle_names,NULL,'NMN',SUBSTR(per1.middle_names,1,1)||'. ') || per1.last_name person_name
201: from per_all_people_f per1
202: where per1.person_id = p_person_id
203: and NVL(p_effective_date,TRUNC(sysdate)) between per1.effective_start_date and per1.effective_end_date;
204:
205: CURSOR c_agency_use(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS