APPS.OTA_CPE_UTIL dependencies on OTA_DELEGATE_BOOKINGS

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 2032: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

2028: and cme.cert_member_id = cmb.certification_member_id
2029: and object_type = 'H';
2030:
2031: l_booking_status_type ota_booking_status_types.type%TYPE;
2032: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
2033: do_update boolean := false;
2034: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE;
2035:
2036: begin

Line 2372: ota_delegate_bookings tdb,

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
2376: AND (

Line 2414: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

2410:
2411: l_cert_enrl_rec csr_cert_enrl%ROWTYPE;
2412: l_prd_enrl_rec csr_prd_enrl%ROWTYPE;
2413: l_booking_status_type ota_booking_status_types.type%TYPE;
2414: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
2415:
2416: l_cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%TYPE;
2417: l_cert_period_end_date ota_cert_prd_enrollments.cert_period_end_date%TYPE;
2418: l_cert_completion_date ota_cert_enrollments.completion_date%type;