APPS.OTA_TFL_API_BUSINESS_RULES dependencies on OTA_RESOURCE_BOOKINGS

Line 289: from ota_resource_bookings trb

285: v_proc varchar2(72) := g_package||'check_vendor';
286: --
287: cursor sel_resource_vendor is
288: select tsr.vendor_id
289: from ota_resource_bookings trb
290: , ota_suppliable_resources tsr
291: where trb.resource_booking_id = p_resource_booking_id
292: and tsr.supplied_resource_id = trb.supplied_resource_id;
293: --

Line 1098: ota_resource_bookings trb

1094: --
1095: cursor sel_resource_book_currency is
1096: select tsr.currency_code
1097: from ota_suppliable_resources tsr,
1098: ota_resource_bookings trb
1099: where tsr.supplied_resource_id = trb.supplied_resource_id
1100: and trb.resource_booking_id = p_resource_booking_id;
1101:
1102: /* select decode(evt.event_id,'',v_header_currency_code

Line 1104: from ota_resource_bookings trb

1100: and trb.resource_booking_id = p_resource_booking_id;
1101:
1102: /* select decode(evt.event_id,'',v_header_currency_code
1103: ,evt.currency_code)
1104: from ota_resource_bookings trb
1105: , ota_events evt
1106: where trb.resource_booking_id = p_resource_booking_id
1107: and evt.event_id(+) = trb.event_id;*/
1108: --

Line 1264: from ota_resource_bookings trb

1260: and evt.event_id = tdb.event_id;
1261: --
1262: cursor sel_resource_book_currency is
1263: select evt.currency_code
1264: from ota_resource_bookings trb
1265: , ota_events evt
1266: where trb.resource_booking_id = p_resource_booking_id
1267: and evt.event_id = trb.event_id;
1268: --