DBA Data[Home] [Help]

APPS.OTA_BST_API dependencies on OTA_BOOKING_STATUS_HISTORIES

Line 415: -- Delete not allowed if any OTA_BOOKING_STATUS_HISTORIES rows exist

411: -- ----------------------------------------------------------------------------
412: -- -------------------------------< CHECK_BSH_EXISTS >-------------------------
413: -- ----------------------------------------------------------------------------
414: --
415: -- Delete not allowed if any OTA_BOOKING_STATUS_HISTORIES rows exist
416: -- for this BOOKING_STATUS_TYPE_ID.
417: --
418: procedure CHECK_BSH_EXISTS (
419: P_BOOKING_STATUS_TYPE_ID in number

Line 429: from OTA_BOOKING_STATUS_HISTORIES

425: W_OK varchar2 (3);
426: --
427: cursor C1 is
428: select 'NO'
429: from OTA_BOOKING_STATUS_HISTORIES
430: BSH
431: where BSH.BOOKING_STATUS_TYPE_ID
432: = P_BOOKING_STATUS_TYPE_ID;
433: --