The following lines contain the word 'select', 'insert', 'update' or 'delete':
select xrc.name
from ben_ext_rcd xrc,
ben_ext_data_elmt_in_rcd xer
where g_old_rec.ext_data_elmt_id = xer.ext_data_elmt_id
and xrc.ext_rcd_id = xer.ext_rcd_id;
select xel.name
from ben_ext_data_elmt xel
where g_old_rec.ext_data_elmt_id = xel.ttl_sum_ext_data_elmt_id;
select xel.name
from ben_ext_data_elmt xel,
ben_ext_where_clause xwc
where g_old_rec.ext_data_elmt_id = xwc.cond_ext_data_elmt_id
and xel.ext_data_elmt_id = xwc.ext_data_elmt_id;
select
ext_data_elmt_id,
name,
xml_tag_name,
data_elmt_typ_cd,
data_elmt_rl,
frmt_mask_cd,
string_val,
dflt_val,
max_length_num,
just_cd,
ttl_fnctn_cd,
ttl_cond_oper_cd,
ttl_cond_val,
ttl_sum_ext_data_elmt_id,
ttl_cond_ext_data_elmt_id,
ext_fld_id,
business_group_id,
legislation_code,
xel_attribute_category,
xel_attribute1,
xel_attribute2,
xel_attribute3,
xel_attribute4,
xel_attribute5,
xel_attribute6,
xel_attribute7,
xel_attribute8,
xel_attribute9,
xel_attribute10,
xel_attribute11,
xel_attribute12,
xel_attribute13,
xel_attribute14,
xel_attribute15,
xel_attribute16,
xel_attribute17,
xel_attribute18,
xel_attribute19,
xel_attribute20,
xel_attribute21,
xel_attribute22,
xel_attribute23,
xel_attribute24,
xel_attribute25,
xel_attribute26,
xel_attribute27,
xel_attribute28,
xel_attribute29,
xel_attribute30,
defined_balance_id,
last_update_date,
creation_date,
last_updated_by,
last_update_login,
created_by ,
object_version_number
from ben_ext_data_elmt
where ext_data_elmt_id = p_ext_data_elmt_id;
select ext_data_elmt_id,
name,
xml_tag_name,
data_elmt_typ_cd,
data_elmt_rl,
frmt_mask_cd,
string_val,
dflt_val,
max_length_num,
just_cd,
ttl_fnctn_cd,
ttl_cond_oper_cd,
ttl_cond_val,
ttl_sum_ext_data_elmt_id,
ttl_cond_ext_data_elmt_id,
ext_fld_id,
business_group_id,
legislation_code,
xel_attribute_category,
xel_attribute1,
xel_attribute2,
xel_attribute3,
xel_attribute4,
xel_attribute5,
xel_attribute6,
xel_attribute7,
xel_attribute8,
xel_attribute9,
xel_attribute10,
xel_attribute11,
xel_attribute12,
xel_attribute13,
xel_attribute14,
xel_attribute15,
xel_attribute16,
xel_attribute17,
xel_attribute18,
xel_attribute19,
xel_attribute20,
xel_attribute21,
xel_attribute22,
xel_attribute23,
xel_attribute24,
xel_attribute25,
xel_attribute26,
xel_attribute27,
xel_attribute28,
xel_attribute29,
xel_attribute30,
defined_balance_id,
last_update_date,
creation_date,
last_updated_by,
last_update_login,
created_by ,
object_version_number
from ben_ext_data_elmt
where ext_data_elmt_id = p_ext_data_elmt_id
for update nowait;
p_last_update_date in date,
p_creation_date in date,
p_last_updated_by in number,
p_last_update_login in number,
p_created_by in number,
p_object_version_number in number
)
Return g_rec_type is
--
l_rec g_rec_type;
l_rec.last_update_date := p_last_update_date;
l_rec.last_updated_by := p_last_updated_by;
l_rec.last_update_login := p_last_update_login;