349: tpe.start_date and nvl(tpe.end_date,evt.course_start_date)
350: and (( evt.activity_version_id = tpe.activity_version_id
351: and not exists
352: (select null
353: from ota_vendor_supplies tvs
354: , ota_price_list_entries tpe2
355: where tvs.vendor_id = evt.vendor_id
356: and tvs.activity_version_id = evt.activity_version_id
357: and tpe2.vendor_supply_id = tvs.vendor_supply_id
362: )
363: or
364: ( exists
365: (select null
366: from ota_vendor_supplies tvs
367: where tvs.vendor_id = evt.vendor_id
368: and tvs.activity_version_id = evt.activity_version_id
369: and tpe.vendor_supply_id = tvs.vendor_supply_id)
370: ));