APPS.PA_PROJECTS_MAINT_UTILS dependencies on PER_ALL_PEOPLE_F

Line 511: FROM per_all_people_f PE

507:
508: CURSOR C1( p_person_id NUMBER)
509: IS
510: Select PE.full_name
511: FROM per_all_people_f PE
512: WHERE PE.PERSON_ID = p_person_id
513: AND trunc(sysdate) between PE.EFFECTIVE_START_DATE AND nvl(PE.EFFECTIVE_END_DATE,sysdate+1); --Included by avaithia for Bug 3448680
514:
515: l_manager_id NUMBER(10);