APPS.OTA_BSL_BUS dependencies on OTA_BOOKING_STATUS_TYPES_TL

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 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