APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on PER_ALL_PEOPLE_F

Line 7: FROM per_all_people_f

3:
4:
5: CURSOR csr_get_person_name(p_person_id NUMBER) IS
6: SELECT full_name
7: FROM per_all_people_f
8: WHERE trunc(sysdate) between effective_start_date and effective_end_date
9: AND person_id = p_person_id;
10:
11: CURSOR get_class_name(p_event_id IN NUMBER) IS

Line 59: FUNCTION learner_is_notSelected(p_person_id IN per_all_people_f.person_id%type

55: p_organization_id IN ota_event_associations.organization_id%type,
56: p_person_id IN per_people_f.person_id%type)
57: RETURN VARCHAR2;
58:
59: FUNCTION learner_is_notSelected(p_person_id IN per_all_people_f.person_id%type
60: ,p_assignment_id per_all_assignments_f.assignment_id%type
61: ,p_event_id IN ota_events.event_id%type)
62: RETURN Boolean;
63: