The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
rate_id
,business_group_id
,parent_spine_id
,name
,rate_type
,rate_uom
,comments
,request_id
,program_application_id
,program_id
,program_update_date
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,rate_basis
,asg_rate_type
,object_version_number
FROM pay_rates
WHERE rate_id = p_rate_id;
SELECT
rate_id
,business_group_id
,parent_spine_id
,name
,rate_type
,rate_uom
,comments
,request_id
,program_application_id
,program_id
,program_update_date
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,rate_basis
,asg_rate_type
,object_version_number
FROM pay_rates
WHERE rate_id = p_rate_id
FOR UPDATE NOWAIT;