APPS.OTA_CPE_UTIL dependencies on OTA_EVENTS

Line 15: Procedure crt_comp_upd_succ_att(p_event_id in ota_events.event_id%type,

11: -- |----------------------< crt_comp_upd_succ_att >-----------------------------|
12: -- ---------------------------------------------------------------------------
13: --
14:
15: Procedure crt_comp_upd_succ_att(p_event_id in ota_events.event_id%type,
16: p_person_id in number
17: )
18: is
19:

Line 33: ota_events evt

29: ota_cert_enrollments cre,
30: ota_cert_prd_enrollments cpe,
31: ota_cert_mbr_enrollments cme,
32: ota_certification_members cmb,
33: ota_events evt
34:
35: where evt.event_id = p_event_id
36: and evt.activity_version_id = tav.activity_version_id
37: AND cmb.object_id = tav.activity_version_id

Line 116: From ota_events evt,ota_delegate_bookings tdb,ota_booking_status_types bst

112:
113: Cursor Csr_Crt_mbr_cls_status(p_act_version_id ota_activity_versions.activity_version_id%Type
114: ) is
115: Select tdb.successful_attendance_flag
116: From ota_events evt,ota_delegate_bookings tdb,ota_booking_status_types bst
117: Where
118: evt.activity_version_id = p_act_version_id
119: and tdb.event_id = evt.event_id
120: and tdb.booking_status_type_id = bst.booking_status_type_id

Line 2185: function check_active_periods(p_event_id ota_events.event_id%type) return varchar2

2181: hr_utility.set_location('Leaving :'||l_proc,15);
2182: RETURN NULL;
2183: end get_elapsed_due_date;
2184:
2185: function check_active_periods(p_event_id ota_events.event_id%type) return varchar2
2186: is
2187: cursor csr_onl_sync_flag is
2188: select csu.online_flag,
2189: csu.synchronous_flag,

Line 2193: ota_events evt

2189: csu.synchronous_flag,
2190: ofr.offering_id
2191: from ota_category_usages csu,
2192: ota_offerings ofr,
2193: ota_events evt
2194: where evt.event_id = p_event_id
2195: and evt.parent_offering_id = ofr.offering_id
2196: and ofr.delivery_mode_id = csu.category_usage_id;
2197:

Line 2371: FROM ota_events evt,

2367: evt.event_type,
2368: tdb.DATE_STATUS_CHANGED,
2369: evt.COURSE_START_DATE,
2370: evt.COURSE_END_DATE
2371: FROM ota_events evt,
2372: ota_delegate_bookings tdb,
2373: ota_booking_status_types bst
2374: WHERE evt.event_id = tdb.event_id
2375: AND bst.booking_status_type_id = tdb.booking_status_type_id