[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
crt_ordr_id,
crt_ordr_typ_cd,
apls_perd_endg_dt,
apls_perd_strtg_dt,
crt_ident,
description,
detd_qlfd_ordr_dt,
issue_dt,
qdro_amt,
qdro_dstr_mthd_cd,
qdro_pct,
rcvd_dt,
uom,
crt_issng,
pl_id,
person_id,
business_group_id,
crt_attribute_category,
crt_attribute1,
crt_attribute2,
crt_attribute3,
crt_attribute4,
crt_attribute5,
crt_attribute6,
crt_attribute7,
crt_attribute8,
crt_attribute9,
crt_attribute10,
crt_attribute11,
crt_attribute12,
crt_attribute13,
crt_attribute14,
crt_attribute15,
crt_attribute16,
crt_attribute17,
crt_attribute18,
crt_attribute19,
crt_attribute20,
crt_attribute21,
crt_attribute22,
crt_attribute23,
crt_attribute24,
crt_attribute25,
crt_attribute26,
crt_attribute27,
crt_attribute28,
crt_attribute29,
crt_attribute30,
object_version_number,
qdro_num_pymt_val,
qdro_per_perd_cd,
pl_typ_id
from ben_crt_ordr
where crt_ordr_id = p_crt_ordr_id;
select crt_ordr_id,
crt_ordr_typ_cd,
apls_perd_endg_dt,
apls_perd_strtg_dt,
crt_ident,
description,
detd_qlfd_ordr_dt,
issue_dt,
qdro_amt,
qdro_dstr_mthd_cd,
qdro_pct,
rcvd_dt,
uom,
crt_issng,
pl_id,
person_id,
business_group_id,
crt_attribute_category,
crt_attribute1,
crt_attribute2,
crt_attribute3,
crt_attribute4,
crt_attribute5,
crt_attribute6,
crt_attribute7,
crt_attribute8,
crt_attribute9,
crt_attribute10,
crt_attribute11,
crt_attribute12,
crt_attribute13,
crt_attribute14,
crt_attribute15,
crt_attribute16,
crt_attribute17,
crt_attribute18,
crt_attribute19,
crt_attribute20,
crt_attribute21,
crt_attribute22,
crt_attribute23,
crt_attribute24,
crt_attribute25,
crt_attribute26,
crt_attribute27,
crt_attribute28,
crt_attribute29,
crt_attribute30,
object_version_number,
qdro_num_pymt_val,
qdro_per_perd_cd,
pl_typ_id
from ben_crt_ordr
where crt_ordr_id = p_crt_ordr_id
for update nowait;