DBA Data[Home] [Help]

APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on OTA_EVENTS_TL

Line 13: FROM OTA_EVENTS_TL

9: AND person_id = p_person_id;
10:
11: CURSOR get_class_name(p_event_id IN NUMBER) IS
12: SELECT title
13: FROM OTA_EVENTS_TL
14: WHERE event_id = p_event_id
15: AND language=userenv('LANG');
16:
17: CURSOR get_all_mandatory_enr_requests(p_conc_request_id IN NUMBER) IS

Line 43: ota_events_tl evt_tl

39: reqm.create_enrollment create_enrollment,
40: reqm.error_message error_message
41: FROM
42: ota_mandatory_enr_req_members reqm,
43: ota_events_tl evt_tl
44: WHERE
45: evt_tl.event_id = reqm.event_id
46: AND(reqm.create_enrollment = 'N' or reqm.error_message IS NOT NULL)
47: AND evt_tl.language=userenv('LANG');