eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_BSL_BUS dependencies on OTA_BOOKING_STATUS_TYPES

Line 61: from OTA_BOOKING_STATUS_TYPES BST, OTA_BOOKING_STATUS_TYPES_TL BSTT

57: V_UNIQUE varchar (3);
58: --
59: cursor CSR_UNIQUE is
60: select 'NO'
61: from OTA_BOOKING_STATUS_TYPES BST, OTA_BOOKING_STATUS_TYPES_TL BSTT
62: WHERE upper (BSTT.NAME) = upper (P_NAME)
63: AND BSTT.BOOKING_STATUS_TYPE_ID = BST.BOOKING_STATUS_TYPE_ID
64: AND bstt.language = p_language
65: AND (BSTT.BOOKING_STATUS_TYPE_ID <> P_BOOKING_STATUS_TYPE_ID OR P_BOOKING_STATUS_TYPE_ID IS NULL)

Line 107: from ota_booking_status_types bst

103: -- Declare cursor
104: --
105: cursor csr_bstbsg is
106: select bst.business_group_id
107: from ota_booking_status_types bst
108: where bst.booking_status_type_id = NVL(p_rec.booking_status_type_id,p_booking_status_type_id);
109: --
110: l_business_group_id ota_booking_status_types.business_group_id%TYPE;
111: --

Line 110: l_business_group_id ota_booking_status_types.business_group_id%TYPE;

106: select bst.business_group_id
107: from ota_booking_status_types bst
108: where bst.booking_status_type_id = NVL(p_rec.booking_status_type_id,p_booking_status_type_id);
109: --
110: l_business_group_id ota_booking_status_types.business_group_id%TYPE;
111: --
112: Begin
113: --
114: hr_utility.set_location('Entering:'||l_proc,5);

Line 202: ,ota_booking_status_types bst

198: cursor csr_sec_grp is
199: select pbg.security_group_id,
200: pbg.legislation_code
201: from per_business_groups pbg
202: ,ota_booking_status_types bst
203: where bst.booking_status_type_id = p_booking_status_type_id
204: and pbg.business_group_id = bst.business_group_id ;
205: --
206: -- Declare local variables

Line 274: , ota_booking_status_types_tl bstl

270: --
271: cursor csr_leg_code is
272: select pbg.legislation_code
273: from per_business_groups pbg
274: , ota_booking_status_types_tl bstl
275: , ota_booking_status_types bst
276: where bstl.booking_status_type_id = p_booking_status_type_id
277: and bstl.language = p_language
278: and pbg.business_group_id = bst.business_group_id

Line 275: , ota_booking_status_types bst

271: cursor csr_leg_code is
272: select pbg.legislation_code
273: from per_business_groups pbg
274: , ota_booking_status_types_tl bstl
275: , ota_booking_status_types bst
276: where bstl.booking_status_type_id = p_booking_status_type_id
277: and bstl.language = p_language
278: and pbg.business_group_id = bst.business_group_id
279: and bst.booking_status_type_id = bstl.booking_status_type_id ;