The following lines contain the word 'select', 'insert', 'update' or 'delete':
select xfi.name
from ben_ext_file xfi,
ben_ext_rcd_in_file xrf
where xrf.ext_rcd_id = g_old_rec.ext_rcd_id
and xrf.ext_file_id = xfi.ext_file_id;
select
ext_rcd_id,
name,
xml_tag_name,
rcd_type_cd,
low_lvl_cd,
business_group_id,
legislation_code,
xrc_attribute_category,
xrc_attribute1,
xrc_attribute2,
xrc_attribute3,
xrc_attribute4,
xrc_attribute5,
xrc_attribute6,
xrc_attribute7,
xrc_attribute8,
xrc_attribute9,
xrc_attribute10,
xrc_attribute11,
xrc_attribute12,
xrc_attribute13,
xrc_attribute14,
xrc_attribute15,
xrc_attribute16,
xrc_attribute17,
xrc_attribute18,
xrc_attribute19,
xrc_attribute20,
xrc_attribute21,
xrc_attribute22,
xrc_attribute23,
xrc_attribute24,
xrc_attribute25,
xrc_attribute26,
xrc_attribute27,
xrc_attribute28,
xrc_attribute29,
xrc_attribute30,
last_update_date,
creation_date,
last_updated_by,
last_update_login,
created_by ,
object_version_number
from ben_ext_rcd
where ext_rcd_id = p_ext_rcd_id;
select ext_rcd_id,
name,
xml_tag_name,
rcd_type_cd,
low_lvl_cd,
business_group_id,
legislation_code,
xrc_attribute_category,
xrc_attribute1,
xrc_attribute2,
xrc_attribute3,
xrc_attribute4,
xrc_attribute5,
xrc_attribute6,
xrc_attribute7,
xrc_attribute8,
xrc_attribute9,
xrc_attribute10,
xrc_attribute11,
xrc_attribute12,
xrc_attribute13,
xrc_attribute14,
xrc_attribute15,
xrc_attribute16,
xrc_attribute17,
xrc_attribute18,
xrc_attribute19,
xrc_attribute20,
xrc_attribute21,
xrc_attribute22,
xrc_attribute23,
xrc_attribute24,
xrc_attribute25,
xrc_attribute26,
xrc_attribute27,
xrc_attribute28,
xrc_attribute29,
xrc_attribute30,
last_update_date,
creation_date,
last_updated_by,
last_update_login,
created_by ,
object_version_number
from ben_ext_rcd
where ext_rcd_id = p_ext_rcd_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;