The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
recruiting_site_id
,date_from
,date_to
,posting_username
,posting_password
,internal
,external
,third_party
,posting_cost
,posting_cost_period
,posting_cost_currency
,stylesheet
,attribute_category
,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
,internal_name
from irc_all_recruiting_sites
where recruiting_site_id = p_recruiting_site_id;
select
recruiting_site_id
,date_from
,date_to
,posting_username
,posting_password
,internal
,external
,third_party
,posting_cost
,posting_cost_period
,posting_cost_currency
,stylesheet
,attribute_category
,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
,internal_name
from irc_all_recruiting_sites
where recruiting_site_id = p_recruiting_site_id
for update nowait;