[Home] [Help]
585: is
586: select
587: --added after show n tell
588: oev.activity_version_id,oev.actual_cost, oev.budget_currency_code,
589: oev.parent_offering_id,ota_timezone_util.get_timezone_name(oev.timezone) timezone
590: from ota_events_tl evt, ota_events oev
591: where evt.event_id =oev.event_id
592: and oev.event_id = l_event_id
593: and evt.language=USERENV('LANG');
714: cursor get_event_info
715: is
716: select evt.title,
717: oev.course_start_date,oev.course_end_date,oev.course_start_time, oev.course_end_time,
718: oev.location_id,oev.event_type,ota_timezone_util.get_timezone_name(oev.timezone)
719: from ota_events_tl evt, ota_events oev
720: where evt.event_id =oev.event_id
721: and oev.event_id = p_eventid
722: and evt.language= USERENV('LANG');
723:
724: cursor get_all_resources_info
725: is
726: select distinct(osr.trainer_id) trainer_id ,orb.required_date_from,orb.required_date_to,
727: orb.required_start_time,orb.required_end_time,orb.status,ota_timezone_util.get_timezone_name(orb.timezone_code) timezone,
728: orb.resource_booking_id resource_booking_id
729: from ota_resource_bookings orb,ota_suppliable_resources osr
730: where orb.supplied_resource_id = osr.supplied_resource_id
731: and osr.resource_type ='T'
734:
735: cursor get_resource_info
736: is
737: select osr.trainer_id trainer_id ,orb.required_date_from,orb.required_date_to,
738: orb.required_start_time,orb.required_end_time,orb.status,ota_timezone_util.get_timezone_name(orb.timezone_code) timezone,
739: orb.resource_booking_id resource_booking_id
740: from ota_resource_bookings orb,ota_suppliable_resources osr
741: where orb.supplied_resource_id = osr.supplied_resource_id
742: and osr.supplied_resource_id = p_sup_res_id