DBA Data[Home] [Help]

APPS.OTA_BST_API dependencies on OTA_BOOKING_STATUS_EXCL

Line 496: -- Delete not allowed if any OTA_BOOKING_STATUS_EXCL rows exist for

492: -- ----------------------------------------------------------------------------
493: -- -------------------------------< CHECK_BSE_EXISTS >-------------------------
494: -- ----------------------------------------------------------------------------
495: --
496: -- Delete not allowed if any OTA_BOOKING_STATUS_EXCL rows exist for
497: -- this BOOKING_STATUS_TYPE_ID.
498: --
499: procedure CHECK_BSE_EXISTS (
500: P_BOOKING_STATUS_TYPE_ID in number

Line 510: from OTA_BOOKING_STATUS_EXCL BSE

506: W_OK varchar2 (3);
507: --
508: cursor C1 is
509: select 'NO'
510: from OTA_BOOKING_STATUS_EXCL BSE
511: where BSE.BOOKING_STATUS_TYPE_ID
512: = P_BOOKING_STATUS_TYPE_ID;
513: --
514: begin