APPS.OTA_ENROLL_IN_TRAINING_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 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 58: FROM ota_booking_status_types

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

Line 255: RETURN ota_booking_status_types%ROWTYPE;

251:
252:
253: FUNCTION Get_Booking_Status_For_Web (p_web_booking_status_type VARCHAR2
254: ,p_business_group_id NUMBER)
255: RETURN ota_booking_status_types%ROWTYPE;
256:
257: --
258: -- ----------------------------------------------------------------------------
259: -- |-------------------------------------------------------|