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,
ben_ext_data_elmt_in_rcd xdr
where xdr.ext_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
and xdr.ext_rcd_id = xdr.ext_rcd_id
and xrf.sort1_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
and xrf.ext_file_id = xfi.ext_file_id;
select xfi.name
from ben_ext_file xfi,
ben_ext_rcd_in_file xrf,
ben_ext_data_elmt_in_rcd xdr
where xdr.ext_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
and xdr.ext_rcd_id = xdr.ext_rcd_id
and xrf.sort2_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
and xrf.ext_file_id = xfi.ext_file_id;
select xfi.name
from ben_ext_file xfi,
ben_ext_rcd_in_file xrf,
ben_ext_data_elmt_in_rcd xdr
where xdr.ext_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
and xdr.ext_rcd_id = xdr.ext_rcd_id
and xrf.sort3_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
and xrf.ext_file_id = xfi.ext_file_id;
select xfi.name
from ben_ext_file xfi,
ben_ext_rcd_in_file xrf,
ben_ext_data_elmt_in_rcd xdr
where xdr.ext_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
and xdr.ext_rcd_id = xdr.ext_rcd_id
and xrf.sort4_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
and xrf.ext_file_id = xfi.ext_file_id;
select xfi.name
from ben_ext_file xfi,
ben_ext_rcd_in_file xrf,
ben_ext_where_clause xwc
where xwc.cond_ext_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
and xwc.ext_rcd_in_file_id = xrf.ext_rcd_in_file_id
and xrf.ext_file_id = xfi.ext_file_id;
select
ext_data_elmt_in_rcd_id,
seq_num,
strt_pos,
dlmtr_val,
rqd_flag,
sprs_cd,
any_or_all_cd,
ext_data_elmt_id,
ext_rcd_id,
business_group_id,
legislation_code,
last_update_date,
creation_date,
last_updated_by,
last_update_login,
created_by ,
object_version_number,
hide_flag
from ben_ext_data_elmt_in_rcd
where ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id;
select ext_data_elmt_in_rcd_id,
seq_num,
strt_pos,
dlmtr_val,
rqd_flag,
sprs_cd,
any_or_all_cd,
ext_data_elmt_id,
ext_rcd_id,
business_group_id,
legislation_code,
last_update_date,
creation_date,
last_updated_by,
last_update_login,
created_by ,
object_version_number,
hide_flag
from ben_ext_data_elmt_in_rcd
where ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_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,
p_hide_flag in varchar2
)
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;