APPS.OTA_CPE_UTIL dependencies on OTA_BOOKING_STATUS_TYPES

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 2031: l_booking_status_type ota_booking_status_types.type%TYPE;

2027: where cme.cert_prd_enrollment_id = p_cert_prd_enrollment_id
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:

Line 2373: ota_booking_status_types bst

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 (
2377: --sync sched, online(conf) or offline(ILT)

Line 2413: l_booking_status_type ota_booking_status_types.type%TYPE;

2409: where cert_prd_enrollment_id = csr_cert_prd_enrollment_id;
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;