APPS.OTA_PMM_SHD SQL Statements

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

Line: 71

    select
		program_membership_id,
	event_id,
	program_event_id,
	object_version_number,
	comments,
	group_name,
	required_flag,
	role,
	sequence,
	pmm_information_category,
	pmm_information1,
	pmm_information2,
	pmm_information3,
	pmm_information4,
	pmm_information5,
	pmm_information6,
	pmm_information7,
	pmm_information8,
	pmm_information9,
	pmm_information10,
	pmm_information11,
	pmm_information12,
	pmm_information13,
	pmm_information14,
	pmm_information15,
	pmm_information16,
	pmm_information17,
	pmm_information18,
	pmm_information19,
	pmm_information20
    from	ota_program_memberships
    where	program_membership_id = p_program_membership_id;

Line: 171

    select 	program_membership_id,
	event_id,
	program_event_id,
	object_version_number,
	comments,
	group_name,
	required_flag,
	role,
	sequence,
	pmm_information_category,
	pmm_information1,
	pmm_information2,
	pmm_information3,
	pmm_information4,
	pmm_information5,
	pmm_information6,
	pmm_information7,
	pmm_information8,
	pmm_information9,
	pmm_information10,
	pmm_information11,
	pmm_information12,
	pmm_information13,
	pmm_information14,
	pmm_information15,
	pmm_information16,
	pmm_information17,
	pmm_information18,
	pmm_information19,
	pmm_information20
    from	ota_program_memberships
    where	program_membership_id = p_program_membership_id
    for	update nowait;