APPS.OTA_EL_TRAINING_SS dependencies on OTA_BOOKING_STATUS_TYPES

Line 1083: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

1079: PROCEDURE process_api2
1080: (p_validate IN BOOLEAN,p_transaction_step_id IN NUMBER) IS
1081:
1082: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
1083: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1084: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
1085: l_eventid ota_events.event_id%TYPE;
1086: l_object_version_number number;
1087: l_person_details OTA_EL_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;

Line 1193: OTA_BOOKING_STATUS_TYPES bst

1189:
1190: CURSOR get_existing_internal IS
1191: SELECT count(*)
1192: FROM OTA_DELEGATE_BOOKINGS dbt,
1193: OTA_BOOKING_STATUS_TYPES bst
1194: WHERE dbt.event_id = l_eventid
1195: AND dbt.internal_booking_flag = 'Y'
1196: AND dbt.booking_status_type_id = bst.booking_status_type_id
1197: AND bst.type in ('P','A','E');

Line 1206: FROM ota_booking_status_types os,

1202: ,p_person_id IN NUMBER) IS
1203: SELECT ov.booking_id,
1204: ov.date_booking_placed,
1205: ov.object_version_number
1206: FROM ota_booking_status_types os,
1207: ota_delegate_bookings ov
1208: WHERE ov.event_id = p_event_id
1209: AND ov.delegate_person_id = p_person_id
1210: AND os.booking_status_type_id = ov.booking_status_type_id