APPS.OTA_LRNG_PATH_MEMBER_UTIL dependencies on OTA_EVENTS

Line 26: ota_events evt,

22: SELECT DECODE(bst.type,'C','Z',bst.type) status,
23: bst.name
24: FROM ota_learning_path_members lpm,
25: ota_lp_member_enrollments lme,
26: ota_events evt,
27: ota_delegate_bookings tdb,
28: ota_booking_status_types_vl bst
29: WHERE lpm.activity_version_id = evt.activity_version_id
30: AND evt.event_id = tdb.event_id

Line 43: FROM ota_events evt,

39:
40: CURSOR csr_act_enr IS
41: SELECT DECODE(bst.type,'C','Z',bst.type) status,
42: bst.name
43: FROM ota_events evt,
44: ota_delegate_bookings tdb,
45: ota_booking_status_types_vl bst
46: WHERE evt.event_id = tdb.event_id
47: AND bst.booking_status_type_id = tdb.booking_status_type_id

Line 112: ota_events evt,

108: SELECT DECODE(bst.type,'C','Z',bst.type) status,
109: tdb.date_status_changed
110: FROM ota_learning_path_members lpm,
111: ota_lp_member_enrollments lme,
112: ota_events evt,
113: ota_delegate_bookings tdb,
114: ota_booking_status_types bst
115: WHERE lpm.activity_version_id = evt.activity_version_id
116: AND evt.event_id = tdb.event_id

Line 128: FROM ota_events evt,

124:
125: CURSOR csr_act_enr IS
126: SELECT DECODE(bst.type,'C','Z',bst.type) status,
127: tdb.date_status_changed
128: FROM ota_events evt,
129: ota_delegate_bookings tdb,
130: ota_booking_status_types_vl bst
131: WHERE evt.event_id = tdb.event_id
132: AND bst.booking_status_type_id = tdb.booking_status_type_id

Line 180: FROM ota_events e,

176: RETURN boolean
177: IS
178: CURSOR chk_enr IS
179: SELECT NULL
180: FROM ota_events e,
181: ota_activity_versions a,
182: ota_delegate_bookings b,
183: ota_booking_status_types s,
184: ota_learning_path_members lpm

Line 410: PROCEDURE update_lme_enroll_status_chg (p_event_id IN ota_events.event_id%TYPE,

406:
407: -- ---------------------------------------------------------------------------
408: -- |----------------------< update_lme_enroll_status_chg >--------------------------|
409: -- ---------------------------------------------------------------------------
410: PROCEDURE update_lme_enroll_status_chg (p_event_id IN ota_events.event_id%TYPE,
411: p_person_id IN ota_lp_enrollments.person_id%TYPE,
412: p_contact_id IN ota_lp_enrollments.contact_id%TYPE,
413: p_lp_enrollment_ids OUT NOCOPY varchar2)
414: IS

Line 421: FROM ota_events

417:
418:
419: CURSOR evt_det IS
420: SELECT activity_version_id
421: FROM ota_events
422: WHERE event_id = p_event_id;
423:
424: --get all the lpms which have the passed event as a component
425: CURSOR csr_lpm_info(csr_activity_version_id number) IS