The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
party_id
,notification_preference_id
,person_id
,matching_jobs
,matching_job_freq
,attribute_category
,receive_info_mail
,allow_access
,address_id
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
,object_version_number
,agency_id
,attempt_id
from irc_notification_preferences
where notification_preference_id = p_notification_preference_id;
select
party_id
,notification_preference_id
,person_id
,matching_jobs
,matching_job_freq
,attribute_category
,receive_info_mail
,allow_access
,address_id
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
,object_version_number
,agency_id
,attempt_id
from irc_notification_preferences
where notification_preference_id = p_notification_preference_id
for update nowait;