APPS.OTA_TEA_SHD SQL Statements

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

Line: 72

    select
		event_association_id,
	event_id,
	customer_id,
        organization_id,
        job_id,
        position_id,
	comments,
	tea_information_category,
	tea_information1,
	tea_information2,
	tea_information3,
	tea_information4,
	tea_information5,
	tea_information6,
	tea_information7,
	tea_information8,
	tea_information9,
	tea_information10,
	tea_information11,
	tea_information12,
	tea_information13,
	tea_information14,
	tea_information15,
	tea_information16,
	tea_information17,
	tea_information18,
	tea_information19,
	tea_information20
    from	ota_event_associations
    where	event_association_id = p_event_association_id;

Line: 176

    select 	event_association_id,
	event_id,
	customer_id,
        organization_id,
        job_id,
        position_id,
	comments,
	tea_information_category,
	tea_information1,
	tea_information2,
	tea_information3,
	tea_information4,
	tea_information5,
	tea_information6,
	tea_information7,
	tea_information8,
	tea_information9,
	tea_information10,
	tea_information11,
	tea_information12,
	tea_information13,
	tea_information14,
	tea_information15,
	tea_information16,
	tea_information17,
	tea_information18,
	tea_information19,
	tea_information20
    from	ota_event_associations
    where	event_association_id = p_event_association_id
    for	update nowait;