The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
ext_crit_prfl_id,
name,
business_group_id,
legislation_code,
xcr_attribute_category,
xcr_attribute1,
xcr_attribute2,
xcr_attribute3,
xcr_attribute4,
xcr_attribute5,
xcr_attribute6,
xcr_attribute7,
xcr_attribute8,
xcr_attribute9,
xcr_attribute10,
xcr_attribute11,
xcr_attribute12,
xcr_attribute13,
xcr_attribute14,
xcr_attribute15,
xcr_attribute16,
xcr_attribute17,
xcr_attribute18,
xcr_attribute19,
xcr_attribute20,
xcr_attribute21,
xcr_attribute22,
xcr_attribute23,
xcr_attribute24,
xcr_attribute25,
xcr_attribute26,
xcr_attribute27,
xcr_attribute28,
xcr_attribute29,
xcr_attribute30,
ext_global_flag,
last_update_date,
creation_date,
last_updated_by,
last_update_login,
created_by ,
object_version_number
from ben_ext_crit_prfl
where ext_crit_prfl_id = p_ext_crit_prfl_id;
select
ext_crit_prfl_id,
name,
business_group_id,
legislation_code,
xcr_attribute_category,
xcr_attribute1,
xcr_attribute2,
xcr_attribute3,
xcr_attribute4,
xcr_attribute5,
xcr_attribute6,
xcr_attribute7,
xcr_attribute8,
xcr_attribute9,
xcr_attribute10,
xcr_attribute11,
xcr_attribute12,
xcr_attribute13,
xcr_attribute14,
xcr_attribute15,
xcr_attribute16,
xcr_attribute17,
xcr_attribute18,
xcr_attribute19,
xcr_attribute20,
xcr_attribute21,
xcr_attribute22,
xcr_attribute23,
xcr_attribute24,
xcr_attribute25,
xcr_attribute26,
xcr_attribute27,
xcr_attribute28,
xcr_attribute29,
xcr_attribute30,
ext_global_flag,
last_update_date,
creation_date,
last_updated_by,
last_update_login,
created_by ,
object_version_number
from ben_ext_crit_prfl
where ext_crit_prfl_id = p_ext_crit_prfl_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;