[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
comp_lvl_fctr_id,
business_group_id,
name,
comp_lvl_det_cd,
comp_lvl_det_rl,
comp_lvl_uom,
comp_src_cd,
defined_balance_id,
no_mn_comp_flag,
no_mx_comp_flag,
mx_comp_val,
mn_comp_val,
rndg_cd,
rndg_rl,
bnfts_bal_id,
comp_alt_val_to_use_cd,
comp_calc_rl,
proration_flag,
start_day_mo,
end_day_mo,
start_year,
end_year,
clf_attribute_category,
clf_attribute1,
clf_attribute2,
clf_attribute3,
clf_attribute4,
clf_attribute5,
clf_attribute6,
clf_attribute7,
clf_attribute8,
clf_attribute9,
clf_attribute10,
clf_attribute11,
clf_attribute12,
clf_attribute13,
clf_attribute14,
clf_attribute15,
clf_attribute16,
clf_attribute17,
clf_attribute18,
clf_attribute19,
clf_attribute20,
clf_attribute21,
clf_attribute22,
clf_attribute23,
clf_attribute24,
clf_attribute25,
clf_attribute26,
clf_attribute27,
clf_attribute28,
clf_attribute29,
clf_attribute30,
object_version_number,
sttd_sal_prdcty_cd
from ben_comp_lvl_fctr
where comp_lvl_fctr_id = p_comp_lvl_fctr_id;
select comp_lvl_fctr_id,
business_group_id,
name,
comp_lvl_det_cd,
comp_lvl_det_rl,
comp_lvl_uom,
comp_src_cd,
defined_balance_id,
no_mn_comp_flag,
no_mx_comp_flag,
mx_comp_val,
mn_comp_val,
rndg_cd,
rndg_rl,
bnfts_bal_id,
comp_alt_val_to_use_cd,
comp_calc_rl,
proration_flag,
start_day_mo,
end_day_mo,
start_year,
end_year,
clf_attribute_category,
clf_attribute1,
clf_attribute2,
clf_attribute3,
clf_attribute4,
clf_attribute5,
clf_attribute6,
clf_attribute7,
clf_attribute8,
clf_attribute9,
clf_attribute10,
clf_attribute11,
clf_attribute12,
clf_attribute13,
clf_attribute14,
clf_attribute15,
clf_attribute16,
clf_attribute17,
clf_attribute18,
clf_attribute19,
clf_attribute20,
clf_attribute21,
clf_attribute22,
clf_attribute23,
clf_attribute24,
clf_attribute25,
clf_attribute26,
clf_attribute27,
clf_attribute28,
clf_attribute29,
clf_attribute30,
object_version_number,
sttd_sal_prdcty_cd
from ben_comp_lvl_fctr
where comp_lvl_fctr_id = p_comp_lvl_fctr_id
for update nowait;