APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on OTA_EVENTS_TL

Line 22: FROM OTA_EVENTS_TL

18: AND person_id = p_person_id;
19:
20: CURSOR get_class_name(p_event_id IN NUMBER) IS
21: SELECT title
22: FROM OTA_EVENTS_TL
23: WHERE event_id = p_event_id
24: AND language=userenv('LANG');
25:
26: CURSOR get_all_mandatory_enr_requests(p_conc_request_id IN NUMBER) IS

Line 70: ota_events_tl evt_tl

66: reqm.error_message error_message
67: FROM
68: ota_mandatory_enr_req_members reqm,
69: ota_mandatory_enr_requests requests,
70: ota_events_tl evt_tl
71: WHERE
72: evt_tl.event_id = reqm.event_id
73: AND(reqm.create_enrollment = 'N' or reqm.error_message IS NOT NULL)
74: AND evt_tl.language=userenv('LANG')

Line 90: ota_events_tl evt_tl

86: reqm.error_message error_message
87: FROM
88: OTA_MAND_MULTI_ENR_REQ_MEMBERS reqm,
89: OTA_MAND_MULTI_ENR_REQUESTS requests,
90: ota_events_tl evt_tl
91: WHERE
92: evt_tl.event_id = reqm.event_id
93: AND(reqm.create_enrollment = 'N' or reqm.error_message IS NOT NULL)
94: AND evt_tl.language=userenv('LANG')