The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
cm_dlvry_mthd_typ_id,
cm_dlvry_mthd_typ_cd,
business_group_id,
cm_typ_id,
cmt_attribute1,
cmt_attribute10,
cmt_attribute11,
cmt_attribute12,
cmt_attribute13,
cmt_attribute14,
cmt_attribute15,
cmt_attribute16,
cmt_attribute17,
cmt_attribute18,
cmt_attribute19,
cmt_attribute2,
cmt_attribute20,
cmt_attribute21,
cmt_attribute22,
cmt_attribute23,
cmt_attribute24,
cmt_attribute25,
cmt_attribute26,
cmt_attribute27,
cmt_attribute28,
cmt_attribute29,
cmt_attribute3,
cmt_attribute30,
rqd_flag,
cmt_attribute_category,
cmt_attribute4,
cmt_attribute5,
cmt_attribute6,
cmt_attribute7,
cmt_attribute8,
cmt_attribute9,
dflt_flag,
object_version_number
from ben_cm_dlvry_mthd_typ
where cm_dlvry_mthd_typ_id = p_cm_dlvry_mthd_typ_id;
select cm_dlvry_mthd_typ_id,
cm_dlvry_mthd_typ_cd,
business_group_id,
cm_typ_id,
cmt_attribute1,
cmt_attribute10,
cmt_attribute11,
cmt_attribute12,
cmt_attribute13,
cmt_attribute14,
cmt_attribute15,
cmt_attribute16,
cmt_attribute17,
cmt_attribute18,
cmt_attribute19,
cmt_attribute2,
cmt_attribute20,
cmt_attribute21,
cmt_attribute22,
cmt_attribute23,
cmt_attribute24,
cmt_attribute25,
cmt_attribute26,
cmt_attribute27,
cmt_attribute28,
cmt_attribute29,
cmt_attribute3,
cmt_attribute30,
rqd_flag,
cmt_attribute_category,
cmt_attribute4,
cmt_attribute5,
cmt_attribute6,
cmt_attribute7,
cmt_attribute8,
cmt_attribute9,
dflt_flag,
object_version_number
from ben_cm_dlvry_mthd_typ
where cm_dlvry_mthd_typ_id = p_cm_dlvry_mthd_typ_id
for update nowait;