APPS.PA_COMP_PROFILE_PUB dependencies on PER_ALL_PEOPLE_F

Line 917: FROM per_all_people_f

913: END;
914:
915: SELECT full_name
916: INTO l_resource_name
917: FROM per_all_people_f
918: WHERE person_id = l_employee_id
919: and trunc(sysdate) between trunc(effective_start_date)
920: and trunc(effective_end_date);
921: x_resource_name := l_resource_name;