APPS.PA_TASK_PUB1 dependencies on PER_ALL_PEOPLE_F

Line 826: from pa_proj_elements ppe, per_all_people_f papf

822: l_project_id NUMBER;
823:
824: CURSOR get_mgr_info IS
825: select ppe.MANAGER_PERSON_ID, papf.FULL_NAME
826: from pa_proj_elements ppe, per_all_people_f papf
827: where ppe.proj_element_id = p_task_id
828: AND ppe.manager_person_id = papf.person_id
829: AND trunc(sysdate) between papf.effective_start_date
830: and nvl(papf.effective_end_date, sysdate+1); --Included by avaithia for Bug # 3448680