APPS.OTA_EVT_SHD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 221

    select
		event_id,
		vendor_id,
		activity_version_id,
		business_group_id,
		organization_id,
		event_type,
		object_version_number,
		title,
        budget_cost,
        actual_cost,
        budget_currency_code,
		centre,
		comments,
		course_end_date,
		course_end_time,
		course_start_date,
		course_start_time,
		duration,
		duration_units,
		enrolment_end_date,
		enrolment_start_date,
		language_id,
		user_status,
		development_event_type,
		event_status,
		price_basis,
		currency_code,
		maximum_attendees,
		maximum_internal_attendees,
		minimum_attendees,
		standard_price,
		category_code,
		parent_event_id,
        book_independent_flag,
        public_event_flag,
        secure_event_flag,
		evt_information_category,
		evt_information1,
		evt_information2,
		evt_information3,
		evt_information4,
		evt_information5,
		evt_information6,
		evt_information7,
		evt_information8,
		evt_information9,
		evt_information10,
		evt_information11,
		evt_information12,
		evt_information13,
		evt_information14,
		evt_information15,
		evt_information16,
		evt_information17,
		evt_information18,
		evt_information19,
		evt_information20,
        project_id,
        owner_id,
        line_id,
        org_id,
        training_center_id,
        location_id,
        offering_id,
        timezone,
        parent_offering_id,
        data_source,
        event_availability
    from	ota_events
    where	event_id = p_event_id;

Line: 317

		-- Select the current row into g_old_rec
		--
		Open C_Sel1;

Line: 355

    select 	event_id,
	vendor_id,
	activity_version_id,
	business_group_id,
	organization_id,
	event_type,
	object_version_number,
	title,
    budget_cost,
    actual_cost,
    budget_currency_code,
	centre,
	comments,
	course_end_date,
	course_end_time,
	course_start_date,
	course_start_time,
	duration,
	duration_units,
	enrolment_end_date,
	enrolment_start_date,
	language_id,
	user_status,
	development_event_type,
	event_status,
	price_basis,
	currency_code,
	maximum_attendees,
	maximum_internal_attendees,
	minimum_attendees,
	standard_price,
	category_code,
	parent_event_id,
    book_independent_flag,
    public_event_flag,
    secure_event_flag,
	evt_information_category,
	evt_information1,
	evt_information2,
	evt_information3,
	evt_information4,
	evt_information5,
	evt_information6,
	evt_information7,
	evt_information8,
	evt_information9,
	evt_information10,
	evt_information11,
	evt_information12,
	evt_information13,
	evt_information14,
	evt_information15,
	evt_information16,
	evt_information17,
	evt_information18,
	evt_information19,
	evt_information20,
    project_id,
    owner_id,
    line_id,
    org_id,
    training_center_id,
    location_id,
    offering_id,
    timezone,
    parent_offering_id,
    data_source,
    event_availability
    from	ota_events
    where	event_id = p_event_id
    for	update nowait;

Line: 646

		select
  event_id
, vendor_id
, activity_version_id
, business_group_id
, organization_id
, event_type
, object_version_number
, title
, budget_cost
, actual_cost
, budget_currency_code
, centre
, comments
, course_end_date
, course_end_time
, course_start_date
, course_start_time
, duration
, duration_units
, enrolment_end_date
, enrolment_start_date
, language_id
, user_status
, development_event_type
, event_status
, price_basis
, currency_code
, maximum_attendees
, maximum_internal_attendees
, minimum_attendees
, standard_price
, category_code
, parent_event_id
, book_independent_flag
, public_event_flag
, secure_event_flag
, evt_information_category
, evt_information1
, evt_information2
, evt_information3
, evt_information4
, evt_information5
, evt_information6
, evt_information7
, evt_information8
, evt_information9
, evt_information10
, evt_information11
, evt_information12
, evt_information13
, evt_information14
, evt_information15
, evt_information16
, evt_information17
, evt_information18
, evt_information19
, evt_information20
, project_id
, owner_id
, line_id
, org_id
, training_center_id
, location_id
, offering_id
, timezone
, parent_offering_id
, data_source
, event_availability
		  from OTA_EVENTS_VL
		  where	EVENT_ID      =	P_EVENT_ID;

Line: 754

    select null
    from   ota_program_memberships mem,
           ota_events evt
    where  mem.program_event_id = p_event_id
    and    mem.event_id = evt.event_id
    and    evt.event_status = 'P';

Line: 900

	select 1
	  from OTA_RESOURCE_BOOKINGS	TRB
	  where TRB.EVENT_ID	      =	P_EVENT_ID;

Line: 940

	select 1
	  from OTA_EVENT_ASSOCIATIONS	TEA
	  where TEA.EVENT_ID	      =	P_EVENT_ID;

Line: 974

		select sum (TFL.MONEY_AMOUNT)
		  from OTA_FINANCE_LINES		TFL,
		       OTA_DELEGATE_BOOKINGS		TDB
		  where TDB.EVENT_ID		      =	P_EVENT_ID
		    and TFL.BOOKING_ID		      = TDB.BOOKING_ID
		    and TFL.CANCELLED_FLAG	     <> 'Y';

Line: 983

		select ol.unit_selling_price,
			 ol.line_id
		from ota_events evt,
		oe_order_lines_all ol
		where evt.event_id = p_event_id and
		      ol.line_id = evt.line_id;