APPS.PA_TASK_PUB1 dependencies on PER_ALL_PEOPLE_F

Line 815: from pa_proj_elements ppe, per_all_people_f papf

811: l_project_id NUMBER;
812:
813: CURSOR get_mgr_info IS
814: select ppe.MANAGER_PERSON_ID, papf.FULL_NAME
815: from pa_proj_elements ppe, per_all_people_f papf
816: where ppe.proj_element_id = p_task_id
817: AND ppe.manager_person_id = papf.person_id
818: AND trunc(sysdate) between papf.effective_start_date
819: and nvl(papf.effective_end_date, sysdate+1); --Included by avaithia for Bug # 3448680