APPS.OTA_PLE_SHD SQL Statements

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

Line: 124

    select
		price_list_entry_id,
	vendor_supply_id,
	activity_version_id,
	price_list_id,
	object_version_number,
	price,
	price_basis,
	start_date,
	comments,
	end_date,
	maximum_attendees,
	minimum_attendees,
	ple_information_category,
	ple_information1,
	ple_information2,
	ple_information3,
	ple_information4,
	ple_information5,
	ple_information6,
	ple_information7,
	ple_information8,
	ple_information9,
	ple_information10,
	ple_information11,
	ple_information12,
	ple_information13,
	ple_information14,
	ple_information15,
	ple_information16,
	ple_information17,
	ple_information18,
	ple_information19,
	ple_information20
    from	ota_price_list_entries
    where	price_list_entry_id = p_price_list_entry_id;

Line: 227

    select 	price_list_entry_id,
	vendor_supply_id,
	activity_version_id,
	price_list_id,
	object_version_number,
	price,
	price_basis,
	start_date,
	comments,
	end_date,
	maximum_attendees,
	minimum_attendees,
	ple_information_category,
	ple_information1,
	ple_information2,
	ple_information3,
	ple_information4,
	ple_information5,
	ple_information6,
	ple_information7,
	ple_information8,
	ple_information9,
	ple_information10,
	ple_information11,
	ple_information12,
	ple_information13,
	ple_information14,
	ple_information15,
	ple_information16,
	ple_information17,
	ple_information18,
	ple_information19,
	ple_information20
    from	ota_price_list_entries
    where	price_list_entry_id = p_price_list_entry_id
    for	update nowait;