APPS.OTA_CLASSIC_UPGRADE dependencies on OTA_BOOKING_STATUS_TYPES

Line 2880: (select booking_status_type_id from ota_booking_status_types

2876: is_history_flag,
2877: booking_status_type_id
2878: FROM ota_delegate_bookings
2879: WHERE BOOKING_STATUS_TYPE_ID in
2880: (select booking_status_type_id from ota_booking_status_types
2881: where type ='P')
2882: AND RowID Between p_start_rowid and p_end_rowid ;
2883:
2884: CURSOR c_learning_object_id IS

Line 2900: FROM ota_booking_status_types

2896:
2897:
2898: CURSOR c_booking_status_type_id IS
2899: SELECT booking_status_type_id
2900: FROM ota_booking_status_types
2901: WHERE type ='A'
2902: AND business_group_id = l_business_group_id
2903: ORDER BY Nvl(Default_flag,'N') Desc;
2904:

Line 2918: (select booking_status_type_id from ota_booking_status_types

2914: UPDATE /*+ ROWID (TDB) */ OTA_DELEGATE_BOOKINGS TDB
2915: SET IS_HISTORY_FLAG = Decode(Is_History_flag,NULL,'Y',Is_History_Flag),
2916: successful_attendance_flag = Decode(successful_attendance_flag,NULL,'Y',successful_attendance_flag)
2917: WHERE BOOKING_STATUS_TYPE_ID in
2918: (select booking_status_type_id from ota_booking_status_types
2919: where type ='A')
2920: AND RowID Between p_start_rowid and p_end_rowid ;
2921:
2922: p_rows_processed := SQL%ROWCOUNT;