APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on PER_ALL_PEOPLE_F

Line 16: FROM per_all_people_f

12: g_processes_tbl g_processes_table;
13:
14: CURSOR csr_get_person_name(p_person_id NUMBER) IS
15: SELECT full_name
16: FROM per_all_people_f
17: WHERE trunc(sysdate) between effective_start_date and effective_end_date
18: AND person_id = p_person_id;
19:
20: CURSOR get_class_name(p_event_id IN NUMBER) IS

Line 126: FUNCTION learner_is_notSelected_inClass(p_person_id IN per_all_people_f.person_id%type

122: p_organization_id IN ota_event_associations.organization_id%type,
123: p_person_id IN per_people_f.person_id%type)
124: RETURN VARCHAR2;
125:
126: FUNCTION learner_is_notSelected_inClass(p_person_id IN per_all_people_f.person_id%type
127: ,p_assignment_id per_all_assignments_f.assignment_id%type
128: ,p_event_id IN ota_events.event_id%type)
129: RETURN Boolean;
130:

Line 131: FUNCTION lrn_is_notSelected_inClass_mul(p_person_id IN per_all_people_f.person_id%type

127: ,p_assignment_id per_all_assignments_f.assignment_id%type
128: ,p_event_id IN ota_events.event_id%type)
129: RETURN Boolean;
130:
131: FUNCTION lrn_is_notSelected_inClass_mul(p_person_id IN per_all_people_f.person_id%type
132: ,p_assignment_id per_all_assignments_f.assignment_id%type
133: ,p_event_id IN ota_events.event_id%type)
134: RETURN Boolean;
135:

Line 202: FUNCTION learner_is_notSelected_inCert(p_person_id IN per_all_people_f.person_id%type

198: l_numberof_records_processed IN OUT NOCOPY NUMBER,
199: l_create_enrollment IN varchar2 default 'Y',
200: p_person_action_id OUT NOCOPY OTA_MAND_MULTI_ENR_REQ_MEMBERS.PERSON_ACTION_ID%type);
201:
202: FUNCTION learner_is_notSelected_inCert(p_person_id IN per_all_people_f.person_id%type
203: ,p_assignment_id per_all_assignments_f.assignment_id%type
204: ,p_certification_id IN ota_certifications_b.certification_id%type default NULL)
205: RETURN Boolean;
206: