APPS.GHR_PA_REQUESTS_PKG dependencies on PER_ALL_PEOPLE_F

Line 234: FROM per_all_people_f per

230: -- therfore plus ',' and ' ' max length is 122!
231:
232: CURSOR cur_per IS
233: SELECT per.last_name||','|| per.first_name||' '|| per.middle_names full_name
234: FROM per_all_people_f per
235: WHERE per.person_id = p_person_id
236: AND NVL(p_effective_date,TRUNC(sysdate)) BETWEEN per.effective_start_date AND per.effective_end_date;
237:
238: BEGIN