DBA Data[Home] [Help]

APPS.OTA_TAV_SHD SQL Statements

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

Line: 107

    select
		activity_version_id,
	activity_id,
	superseded_by_act_version_id,
	developer_organization_id,
	controlling_person_id,
	object_version_number,
	version_name,
	comments,
	description,
	duration,
	duration_units,
	end_date,
	intended_audience,
	language_id,
	maximum_attendees,
	minimum_attendees,
	objectives,
	start_date,
	success_criteria,
	user_status,
      vendor_id,
      actual_cost,
      budget_cost,
      budget_currency_code,
      expenses_allowed,
      professional_credit_type,
      professional_credits,
      maximum_internal_attendees,
	tav_information_category,
	tav_information1,
	tav_information2,
	tav_information3,
	tav_information4,
	tav_information5,
	tav_information6,
	tav_information7,
	tav_information8,
	tav_information9,
	tav_information10,
	tav_information11,
	tav_information12,
	tav_information13,
	tav_information14,
	tav_information15,
	tav_information16,
	tav_information17,
	tav_information18,
	tav_information19,
	tav_information20,
      inventory_item_id,
      organization_id,
      rco_id,
      version_code,
      business_group_id,
      data_source
      ,competency_update_level

    from	ota_activity_versions
    where	activity_version_id = p_activity_version_id;
Line: 234

    select 	activity_version_id,
	activity_id,
	superseded_by_act_version_id,
	developer_organization_id,
	controlling_person_id,
	object_version_number,
	version_name,
	comments,
	description,
	duration,
	duration_units,
	end_date,
	intended_audience,
	language_id,
	maximum_attendees,
	minimum_attendees,
	objectives,
	start_date,
	success_criteria,
	user_status,
      vendor_id,
      actual_cost,
      budget_cost,
      budget_currency_code,
      expenses_allowed,
      professional_credit_type,
      professional_credits,
      maximum_internal_attendees,
	tav_information_category,
	tav_information1,
	tav_information2,
	tav_information3,
	tav_information4,
	tav_information5,
	tav_information6,
	tav_information7,
	tav_information8,
	tav_information9,
	tav_information10,
	tav_information11,
	tav_information12,
	tav_information13,
	tav_information14,
	tav_information15,
	tav_information16,
	tav_information17,
	tav_information18,
	tav_information19,
	tav_information20,
      inventory_item_id,
      organization_id,
      rco_id,
      version_code,
      business_group_id,
      data_source
      ,competency_update_level

    from	ota_activity_versions
    where	activity_version_id = p_activity_version_id
    for	update nowait;
Line: 398

      ,p_competency_update_level        in     varchar2

	)
	Return g_rec_type is
--
  l_rec	  g_rec_type;
Line: 467

   l_rec.competency_update_level          := p_competency_update_level  ;