APPS.PA_PROJECTS_MAINT_UTILS dependencies on PER_ALL_PEOPLE_F

Line 523: FROM per_all_people_f PE

519:
520: CURSOR C1( p_person_id NUMBER)
521: IS
522: Select PE.full_name
523: FROM per_all_people_f PE
524: WHERE PE.PERSON_ID = p_person_id
525: AND trunc(sysdate) between PE.EFFECTIVE_START_DATE AND PE.EFFECTIVE_END_DATE; --Included by avaithia for Bug 3448680
526: /* 6802729 removed nvl() from PE.EFFECTIVE_END_DATE as this is a not null column
527: * */