APPS.OTA_MLS_MIGRATION dependencies on OTA_BOOKING_STATUS_TYPES_TL

Line 329: delete from ota_booking_status_types_tl

325: ** Clear out any existing data for this range of records
326: **
327: ** Don't delete just yet.
328: **
329: delete from ota_booking_status_types_tl
330: where booking_status_type_id between p_start_pkid
331: and p_end_pkid;
332: */
333:

Line 350: Insert into OTA_BOOKING_STATUS_TYPES_TL

346:
347: /*
348: ** Insert the TL rows.
349: */
350: Insert into OTA_BOOKING_STATUS_TYPES_TL
351: (Booking_Status_type_Id,
352: Language,
353: Name,
354: Description,

Line 375: From OTA_BOOKING_STATUS_TYPES_TL T

371: M.Last_Update_Login
372: From OTA_BOOKING_STATUS_TYPES M
373: Where M.Booking_status_type_id Between P_start_pkid and P_end_pkid
374: And Not Exists (Select '1'
375: From OTA_BOOKING_STATUS_TYPES_TL T
376: Where T.Booking_status_type_Id = M.Booking_Status_type_Id
377: And T.Language = L_Current_Language ) ;
378:
379: