APPS.OTA_TRNG_ENROLL_SS dependencies on OTA_BOOKING_STATUS_TYPES

Line 26: FROM ota_booking_status_types bst, ota_booking_status_types_tl bstt

22: bst.BST_INFORMATION9,bst.BST_INFORMATION10,bst.BST_INFORMATION11,
23: bst.BST_INFORMATION12,bst.BST_INFORMATION13,bst.BST_INFORMATION14,
24: bst.BST_INFORMATION15,bst.BST_INFORMATION16,bst.BST_INFORMATION17,
25: bst.BST_INFORMATION18,bst.BST_INFORMATION19,bst.BST_INFORMATION20
26: FROM ota_booking_status_types bst, ota_booking_status_types_tl bstt
27: WHERE bst.business_group_id = p_business_group_id
28: AND bst.booking_status_type_id = bstt.booking_status_type_id
29: AND bstt.language=userenv('LANG')
30: AND rownum=1

Line 41: FROM ota_booking_status_types bst1, ota_booking_status_types_tl bstt1

37: AND ( (bstt.name like 'W:%')
38: -- There are no names like W:, so a defaulted required status is
39: -- the second choice.
40: OR ( NOT EXISTS (SELECT 1
41: FROM ota_booking_status_types bst1, ota_booking_status_types_tl bstt1
42: WHERE bst1.business_group_id = p_business_group_id
43: AND bst1.booking_status_type_id = bstt1.booking_status_type_id
44: AND bstt1.language=userenv('LANG')
45: AND bst1.type =

Line 56: FROM ota_booking_status_types

52: AND ( (bst.default_flag = 'Y')
53: -- If there are no names like 'W:%' and no defaulted status of type
54: -- required, then select one that is of type required
55: OR NOT EXISTS (SELECT 1
56: FROM ota_booking_status_types
57: WHERE business_group_id = p_business_group_id
58: AND type =
59: DECODE(p_web_booking_status_type, 'REQUESTED', 'R'
60: , 'WAITLISTED','W'

Line 252: RETURN OTA_BOOKING_STATUS_TYPES%ROWTYPE;

248:
249:
250: FUNCTION Get_Booking_Status_For_Web (p_web_booking_status_type VARCHAR2
251: ,p_business_group_id NUMBER)
252: RETURN OTA_BOOKING_STATUS_TYPES%ROWTYPE;
253:
254: --
255: -- ----------------------------------------------------------------------------
256: -- |-------------------------------------------------------|