The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
payroll_run_id,
payroll_id,
business_group_id,
payroll_identifier,
period_start_date,
period_end_date,
processing_date,
object_version_number,
bpr_attribute_category,
bpr_attribute1,
bpr_attribute2,
bpr_attribute3,
bpr_attribute4,
bpr_attribute5,
bpr_attribute6,
bpr_attribute7,
bpr_attribute8,
bpr_attribute9,
bpr_attribute10,
bpr_attribute11,
bpr_attribute12,
bpr_attribute13,
bpr_attribute14,
bpr_attribute15,
bpr_attribute16,
bpr_attribute17,
bpr_attribute18,
bpr_attribute19,
bpr_attribute20,
bpr_attribute21,
bpr_attribute22,
bpr_attribute23,
bpr_attribute24,
bpr_attribute25,
bpr_attribute26,
bpr_attribute27,
bpr_attribute28,
bpr_attribute29,
bpr_attribute30
from per_bf_payroll_runs
where payroll_run_id = p_payroll_run_id;
select payroll_run_id,
payroll_id,
business_group_id,
payroll_identifier,
period_start_date,
period_end_date,
processing_date,
object_version_number,
bpr_attribute_category,
bpr_attribute1,
bpr_attribute2,
bpr_attribute3,
bpr_attribute4,
bpr_attribute5,
bpr_attribute6,
bpr_attribute7,
bpr_attribute8,
bpr_attribute9,
bpr_attribute10,
bpr_attribute11,
bpr_attribute12,
bpr_attribute13,
bpr_attribute14,
bpr_attribute15,
bpr_attribute16,
bpr_attribute17,
bpr_attribute18,
bpr_attribute19,
bpr_attribute20,
bpr_attribute21,
bpr_attribute22,
bpr_attribute23,
bpr_attribute24,
bpr_attribute25,
bpr_attribute26,
bpr_attribute27,
bpr_attribute28,
bpr_attribute29,
bpr_attribute30
from per_bf_payroll_runs
where payroll_run_id = p_payroll_run_id
for update nowait;