The following lines contain the word 'select', 'insert', 'update' or 'delete':
select xdf.name
from ben_ext_dfn xdf
where xdf.ext_file_id = g_old_rec.ext_file_id;
select
ext_file_id,
name,
xml_tag_name,
business_group_id,
legislation_code,
xfi_attribute_category,
xfi_attribute1,
xfi_attribute2,
xfi_attribute3,
xfi_attribute4,
xfi_attribute5,
xfi_attribute6,
xfi_attribute7,
xfi_attribute8,
xfi_attribute9,
xfi_attribute10,
xfi_attribute11,
xfi_attribute12,
xfi_attribute13,
xfi_attribute14,
xfi_attribute15,
xfi_attribute16,
xfi_attribute17,
xfi_attribute18,
xfi_attribute19,
xfi_attribute20,
xfi_attribute21,
xfi_attribute22,
xfi_attribute23,
xfi_attribute24,
xfi_attribute25,
xfi_attribute26,
xfi_attribute27,
xfi_attribute28,
xfi_attribute29,
xfi_attribute30,
ext_rcd_in_file_id ,
ext_data_elmt_in_rcd_id1,
ext_data_elmt_in_rcd_id2,
last_update_date,
creation_date,
last_updated_by,
last_update_login,
created_by ,
object_version_number
from ben_ext_file
where ext_file_id = p_ext_file_id;
select ext_file_id,
name,
xml_tag_name,
business_group_id,
legislation_code,
xfi_attribute_category,
xfi_attribute1,
xfi_attribute2,
xfi_attribute3,
xfi_attribute4,
xfi_attribute5,
xfi_attribute6,
xfi_attribute7,
xfi_attribute8,
xfi_attribute9,
xfi_attribute10,
xfi_attribute11,
xfi_attribute12,
xfi_attribute13,
xfi_attribute14,
xfi_attribute15,
xfi_attribute16,
xfi_attribute17,
xfi_attribute18,
xfi_attribute19,
xfi_attribute20,
xfi_attribute21,
xfi_attribute22,
xfi_attribute23,
xfi_attribute24,
xfi_attribute25,
xfi_attribute26,
xfi_attribute27,
xfi_attribute28,
xfi_attribute29,
xfi_attribute30,
ext_rcd_in_file_id ,
ext_data_elmt_in_rcd_id1 ,
ext_data_elmt_in_rcd_id2 ,
last_update_date,
creation_date,
last_updated_by,
last_update_login,
created_by ,
object_version_number
from ben_ext_file
where ext_file_id = p_ext_file_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;