The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
time_recipient_id
,name
,application_id
,object_version_number
,application_retrieval_function
,application_update_process
,appl_validation_process
,application_period_function
,appl_dynamic_template_process
,extension_function1
,extension_function2
from hxc_time_recipients
where time_recipient_id = p_time_recipient_id;
select
time_recipient_id
,name
,application_id
,object_version_number
,application_retrieval_function
,application_update_process
,appl_validation_process
,application_period_function
,appl_dynamic_template_process
,extension_function1
,extension_function2
from hxc_time_recipients
where time_recipient_id = p_time_recipient_id
for update nowait;
,p_appl_update_process in varchar2
,p_appl_validation_process in varchar2
,p_appl_period_function in varchar2
,p_appl_dyn_template_process in varchar2
,p_extension_function1 in varchar2
,p_extension_function2 in varchar2
,p_application_id in number
,p_object_version_number in number
)
Return g_rec_type is
--
l_rec g_rec_type;
l_rec.application_update_process := p_appl_update_process;