APPS.OTA_BST_API dependencies on OTA_BOOKING_STATUS_TYPES_VL

Line 170: from OTA_BOOKING_STATUS_TYPES_VL BST

166: W_BOOKING_STATUS_TYPE_ID number (9);
167: --
168: cursor C1 is
169: select BST.BOOKING_STATUS_TYPE_ID
170: from OTA_BOOKING_STATUS_TYPES_VL BST
171: where BST.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
172: and BST.NAME = P_NAME;
173: --
174: begin

Line 252: from OTA_BOOKING_STATUS_TYPES_VL BST

248: --
249: cursor C_DEFAULT is
250: select BST.BOOKING_STATUS_TYPE_ID,
251: BST.NAME
252: from OTA_BOOKING_STATUS_TYPES_VL BST
253: where BST.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
254: and BST.DEFAULT_FLAG = 'Y'
255: and BST.TYPE <> 'C'
256: and ((P_EVENT_STATUS = 'F' AND -- Bug #1870097. For status 'F' use Waitlist as default, for status 'P' use either Waitlisted or Requested

Line 297: from OTA_BOOKING_STATUS_TYPES_VL BST

293: V_UNIQUE varchar (3);
294: --
295: cursor C_UNIQUE is
296: select 'NO'
297: from OTA_BOOKING_STATUS_TYPES_VL BST
298: where BST.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
299: and upper (BST.NAME) = upper (P_NAME)
300: and ( (P_BOOKING_STATUS_TYPE_ID
301: is null)

Line 346: from OTA_BOOKING_STATUS_TYPES_VL BST

342:
343: --
344: cursor C_DEFAULT is
345: select BST.NAME
346: from OTA_BOOKING_STATUS_TYPES_VL BST
347: where BST.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
348: and BST.TYPE = P_TYPE
349: and BST.DEFAULT_FLAG = 'Y';
350: --

Line 611: from ota_booking_status_types_vl

607: bst_information17,
608: bst_information18,
609: bst_information19,
610: bst_information20
611: from ota_booking_status_types_vl
612: where booking_status_type_id = p_booking_status_type_id;
613: --
614: W_PROC varchar2(72) := G_PACKAGE||'g_old_rec_current';
615: l_fct_ret boolean;