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

1988: where cme.cert_prd_enrollment_id = p_cert_prd_enrollment_id
1989: and cme.cert_member_id = cmb.certification_member_id
1990: and object_type = 'H';
1991:
1992: l_booking_status_type ota_booking_status_types.type%TYPE;
1993: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
1994: do_update boolean := false;
1995: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE;
1996:

Line 2334: ota_booking_status_types bst

2330: evt.COURSE_START_DATE,
2331: evt.COURSE_END_DATE
2332: FROM ota_events evt,
2333: ota_delegate_bookings tdb,
2334: ota_booking_status_types bst
2335: WHERE evt.event_id = tdb.event_id
2336: AND bst.booking_status_type_id = tdb.booking_status_type_id
2337: AND (
2338: --sync sched, online(conf) or offline(ILT)

Line 2374: l_booking_status_type ota_booking_status_types.type%TYPE;

2370: where cert_prd_enrollment_id = csr_cert_prd_enrollment_id;
2371:
2372: l_cert_enrl_rec csr_cert_enrl%ROWTYPE;
2373: l_prd_enrl_rec csr_prd_enrl%ROWTYPE;
2374: l_booking_status_type ota_booking_status_types.type%TYPE;
2375: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
2376:
2377: l_cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%TYPE;
2378: l_cert_period_end_date ota_cert_prd_enrollments.cert_period_end_date%TYPE;