APPS.PQH_TENURE_DETAIL dependencies on PER_ALL_PEOPLE_F

Line 15: FROM per_all_people_f

11: p_start_date OUT NOCOPY DATE ) IS
12:
13: CURSOR emp_cur IS
14: SELECT employee_number, full_name, last_name, title, email_address, start_date
15: FROM per_all_people_f
16: WHERE SYSDATE BETWEEN effective_start_date and effective_end_date
17: AND person_id = p_person_id;
18:
19: l_title VARCHAR2(30);