APPS.OTA_EL_ENROLL_SS dependencies on OTA_BOOKING_STATUS_TYPES

Line 27: FROM ota_booking_status_types bst, ota_booking_status_types_tl bstt

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

Line 42: FROM ota_booking_status_types bst1, ota_booking_status_types_tl bstt1

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

Line 57: FROM ota_booking_status_types

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

Line 253: RETURN OTA_BOOKING_STATUS_TYPES%ROWTYPE;

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