252: , tpl.price_list_type
253: , nvl( tpl.single_unit_price, 0)
254: from ota_booking_deals tbd
255: , ota_price_lists tpl
256: , ota_events evt
257: where tbd.booking_deal_id = p_booking_deal_id
258: and tpl.price_list_id (+) = tbd.price_list_id
259: and evt.event_id = p_event_id
260: and evt.course_start_date between
331: cursor sel_type_E_tpe_event is
332: select decode(p_price_list_type,'T',tpe.price
333: ,tpe.price)
334: , evt.standard_price
335: from ota_events evt
336: , ota_price_list_entries tpe
337: , ota_price_lists tpl
338: where evt.event_id = p_event_id
339: and evt.currency_code = p_currency_code
506: v_proc varchar2(72) := g_package||'set_type_E_evt_amounts';
507: --
508: cursor sel_type_E_evt_event is
509: select evt.standard_price
510: from ota_events evt
511: where evt.event_id = p_event_id
512: and evt.event_id = p_tbd_event_id
513: and evt.currency_code = p_currency_code;
514: --
584: v_proc varchar2(72) := g_package||'set_type_E_tav_amounts';
585: --
586: cursor sel_type_E_tav_event is
587: select evt.standard_price
588: from ota_events evt
589: where evt.event_id = p_event_id
590: and evt.activity_version_id = p_activity_version_id
591: and evt.currency_code = p_currency_code;
592: --
660: v_proc varchar2(72) := g_package||'set_type_E_cat_amounts';
661: --
662: cursor sel_type_E_cat_event is
663: select evt.standard_price
664: from ota_events evt
665: , ota_act_cat_inclusions aci
666: where evt.event_id = p_event_id
667: and aci.activity_version_id = evt.activity_version_id
668: and aci.activity_category = p_category
735: v_proc varchar2(72) := g_package||'set_no_deal_amounts';
736: --
737: cursor sel_event_no_deal is
738: select evt.standard_price
739: from ota_events evt
740: where evt.event_id = p_event_id
741: and evt.currency_code = p_currency_code;
742: --
743: Begin
832: select tdb.event_id
833: , tdb.number_of_places
834: , nvl(evt.price_basis,'S')
835: from ota_delegate_bookings tdb
836: , ota_events evt
837: where tdb.booking_id = p_booking_id
838: and tdb.event_id = evt.event_id;
839:
840: Begin