APPS.OTA_TRAINING_PLAN_UPGRADE dependencies on OTA_BOOKING_STATUS_TYPES

Line 21: ota_booking_status_types bst

17: ,p_contact_id in number) IS
18: SELECT min(date_status_changed)
19: FROM ota_events evt,
20: ota_delegate_bookings tdb,
21: ota_booking_status_types bst
22: WHERE evt.activity_version_id=p_activity_version_id
23: AND evt.event_id = tdb.event_id
24: AND bst.booking_status_type_id = tdb.booking_status_type_id
25: AND (tdb.delegate_person_id = p_person_id or tdb.delegate_person_id = p_contact_id)

Line 2196: l_status ota_booking_status_types.type%type;

2192: l_old_status ota_lp_member_enrollments.member_status_code%type;
2193: l_max_date_status_changed ota_delegate_bookings.date_status_changed%type;
2194: l_date_status_changed ota_delegate_bookings.date_status_changed%type;
2195: l_dummy number;
2196: l_status ota_booking_status_types.type%type;
2197: l_rows_processed number;
2198: l_completion_date date;
2199: l_lpm_enrollment_id number;
2200: l_completed_courses number;

Line 2233: ota_booking_status_types bst

2229: ,p_contact_id in number) IS
2230: SELECT DECODE(bst.type,'C','Z',bst.type) status
2231: FROM ota_events evt,
2232: ota_delegate_bookings tdb,
2233: ota_booking_status_types bst
2234: WHERE evt.activity_version_id=p_activity_version_id
2235: AND evt.event_id = tdb.event_id
2236: AND bst.booking_status_type_id = tdb.booking_status_type_id
2237: AND ((p_person_id is not null and tdb.delegate_person_id = p_person_id )

Line 2262: ota_booking_status_types bst

2258: ota_lp_member_enrollments lpme,
2259: ota_learning_path_members lpm,
2260: ota_lp_enrollments lpe,
2261: ota_events evt,
2262: ota_booking_status_types bst
2263: WHERE tdb.event_id = evt.event_id
2264: AND evt.activity_version_id = lpm.activity_version_id
2265: AND tdb.booking_status_type_id = bst.booking_status_type_id
2266: AND bst.type = 'A'