[Home] [Help]
374: cursor sel_booking_customer is
375: select tdb.customer_id
376: , tdb.source_of_booking
377: from ota_resource_allocations tra
378: , ota_delegate_bookings tdb
379: where tra.resource_allocation_id = p_resource_allocation_id
380: and tdb.booking_id = tra.booking_id;
381: --
382: cursor sel_finance_customer is
470: --
471: cursor sel_booking_customer is
472: select tdb.customer_id
473: , tdb.source_of_booking
474: from ota_delegate_bookings tdb
475: where tdb.booking_id = p_booking_id;
476: --
477: cursor sel_finance_customer is
478: select tfh.customer_id
1070: where tfh.finance_header_id = p_finance_header_id;
1071: --
1072: cursor sel_event_currency is
1073: select evt.currency_code
1074: from ota_delegate_bookings tdb
1075: , ota_events evt
1076: where tdb.booking_id = p_booking_id
1077: and evt.event_id = tdb.event_id;
1078: --
1085: --
1086: cursor sel_resource_alloc_currency is
1087: select evt.currency_code
1088: from ota_resource_allocations tra
1089: , ota_delegate_bookings tdb
1090: , ota_events evt
1091: where tra.resource_allocation_id = p_resource_allocation_id
1092: and tdb.booking_id = tra.booking_id
1093: and evt.event_id = tdb.event_id;
1237: v_proc varchar2(72) := g_package||'get_currency_code';
1238: --
1239: cursor sel_event_currency is
1240: select evt.currency_code
1241: from ota_delegate_bookings tdb
1242: , ota_events evt
1243: where tdb.booking_id = p_booking_id
1244: and evt.event_id = tdb.event_id;
1245: --
1252: --
1253: cursor sel_resource_alloc_currency is
1254: select evt.currency_code
1255: from ota_resource_allocations tra
1256: , ota_delegate_bookings tdb
1257: , ota_events evt
1258: where tra.resource_allocation_id = p_resource_allocation_id
1259: and tdb.booking_id = tra.booking_id
1260: and evt.event_id = tdb.event_id;