APPS.OTA_TSP_SHD SQL Statements

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

Line: 69

    select
		skill_provision_id,
	activity_version_id,
	object_version_number,
	type,
	comments,
	tsp_information_category,
	tsp_information1,
	tsp_information2,
	tsp_information3,
	tsp_information4,
	tsp_information5,
	tsp_information6,
	tsp_information7,
	tsp_information8,
	tsp_information9,
	tsp_information10,
	tsp_information11,
	tsp_information12,
	tsp_information13,
	tsp_information14,
	tsp_information15,
	tsp_information16,
	tsp_information17,
	tsp_information18,
	tsp_information19,
	tsp_information20,
	analysis_criteria_id
    from	ota_skill_provisions
    where	skill_provision_id = p_skill_provision_id;

Line: 166

    select 	skill_provision_id,
	activity_version_id,
	object_version_number,
	type,
	comments,
	tsp_information_category,
	tsp_information1,
	tsp_information2,
	tsp_information3,
	tsp_information4,
	tsp_information5,
	tsp_information6,
	tsp_information7,
	tsp_information8,
	tsp_information9,
	tsp_information10,
	tsp_information11,
	tsp_information12,
	tsp_information13,
	tsp_information14,
	tsp_information15,
	tsp_information16,
	tsp_information17,
	tsp_information18,
	tsp_information19,
	tsp_information20,
	analysis_criteria_id
    from	ota_skill_provisions
    where	skill_provision_id = p_skill_provision_id
    for	update nowait;

Line: 336

  select
        skill_provision_id,
	activity_version_id,
	type,
	comments,
	tsp_information_category,
	tsp_information1,
	tsp_information2,
	tsp_information3,
	tsp_information4,
	tsp_information5,
	tsp_information6,
	tsp_information7,
	tsp_information8,
	tsp_information9,
	tsp_information10,
	tsp_information11,
	tsp_information12,
	tsp_information13,
	tsp_information14,
	tsp_information15,
	tsp_information16,
	tsp_information17,
	tsp_information18,
	tsp_information19,
	tsp_information20,
	analysis_criteria_id
    from	ota_skill_provisions
    where	activity_version_id = p_activity_version_from;