The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
ext_crit_val_id,
val_1,
val_2,
ext_crit_typ_id,
business_group_id,
ext_crit_bg_id ,
legislation_code,
last_update_date,
creation_date,
last_updated_by,
last_update_login,
created_by ,
object_version_number
from ben_ext_crit_val
where ext_crit_val_id = p_ext_crit_val_id;
select ext_crit_val_id,
val_1,
val_2,
ext_crit_typ_id,
business_group_id,
ext_crit_bg_id,
legislation_code,
last_update_date,
creation_date,
last_updated_by,
last_update_login,
created_by ,
object_version_number
from ben_ext_crit_val
where ext_crit_val_id = p_ext_crit_val_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;