The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
ext_dfn_id,
name,
xml_tag_name,
xdo_template_id,
data_typ_cd,
ext_typ_cd,
output_name,
output_type,
apnd_rqst_id_flag,
prmy_sort_cd,
scnd_sort_cd,
strt_dt,
end_dt,
ext_crit_prfl_id,
ext_file_id,
business_group_id,
legislation_code,
xdf_attribute_category,
xdf_attribute1,
xdf_attribute2,
xdf_attribute3,
xdf_attribute4,
xdf_attribute5,
xdf_attribute6,
xdf_attribute7,
xdf_attribute8,
xdf_attribute9,
xdf_attribute10,
xdf_attribute11,
xdf_attribute12,
xdf_attribute13,
xdf_attribute14,
xdf_attribute15,
xdf_attribute16,
xdf_attribute17,
xdf_attribute18,
xdf_attribute19,
xdf_attribute20,
xdf_attribute21,
xdf_attribute22,
xdf_attribute23,
xdf_attribute24,
xdf_attribute25,
xdf_attribute26,
xdf_attribute27,
xdf_attribute28,
xdf_attribute29,
xdf_attribute30,
last_update_date,
creation_date,
last_updated_by,
last_update_login,
created_by ,
object_version_number,
drctry_name,
kickoff_wrt_prc_flag,
upd_cm_sent_dt_flag,
spcl_hndl_flag,
ext_global_flag,
cm_display_flag,
use_eff_dt_for_chgs_flag,
ext_post_prcs_rl
from ben_ext_dfn
where ext_dfn_id = p_ext_dfn_id;
select ext_dfn_id,
name,
xml_tag_name,
xdo_template_id,
data_typ_cd,
ext_typ_cd,
output_name,
output_type,
apnd_rqst_id_flag,
prmy_sort_cd,
scnd_sort_cd,
strt_dt,
end_dt,
ext_crit_prfl_id,
ext_file_id,
business_group_id,
legislation_code,
xdf_attribute_category,
xdf_attribute1,
xdf_attribute2,
xdf_attribute3,
xdf_attribute4,
xdf_attribute5,
xdf_attribute6,
xdf_attribute7,
xdf_attribute8,
xdf_attribute9,
xdf_attribute10,
xdf_attribute11,
xdf_attribute12,
xdf_attribute13,
xdf_attribute14,
xdf_attribute15,
xdf_attribute16,
xdf_attribute17,
xdf_attribute18,
xdf_attribute19,
xdf_attribute20,
xdf_attribute21,
xdf_attribute22,
xdf_attribute23,
xdf_attribute24,
xdf_attribute25,
xdf_attribute26,
xdf_attribute27,
xdf_attribute28,
xdf_attribute29,
xdf_attribute30,
last_update_date,
creation_date,
last_updated_by,
last_update_login,
created_by ,
object_version_number,
drctry_name,
kickoff_wrt_prc_flag,
upd_cm_sent_dt_flag,
spcl_hndl_flag,
ext_global_flag,
cm_display_flag,
use_eff_dt_for_chgs_flag,
ext_post_prcs_rl
from ben_ext_dfn
where ext_dfn_id = p_ext_dfn_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,
p_drctry_name in varchar2,
p_kickoff_wrt_prc_flag in varchar2,
p_upd_cm_sent_dt_flag in varchar2,
p_spcl_hndl_flag in varchar2,
p_ext_global_flag in varchar2,
p_cm_display_flag in varchar2,
p_use_eff_dt_for_chgs_flag in varchar2,
p_ext_post_prcs_rl 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;