The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
process_event_id
,assignment_id
,effective_date
,change_type
,status
,description
,event_update_id
,business_group_id
,org_process_event_group_id
,surrogate_key
,object_version_number
,calculation_date
,retroactive_status
,noted_value
from pay_process_events
where process_event_id = p_process_event_id;
select
process_event_id
,assignment_id
,effective_date
,change_type
,status
,description
,event_update_id
,business_group_id
,org_process_event_group_id
,surrogate_key
,object_version_number
,calculation_date
,retroactive_status
,noted_value
from pay_process_events
where process_event_id = p_process_event_id
for update nowait;
,p_event_update_id in number
,p_business_group_id in number
,p_org_process_event_group_id in number
,p_surrogate_key in varchar2
,p_object_version_number in number
,p_calculation_date in date
,p_retroactive_status in varchar2
,p_noted_value in varchar2
)
Return g_rec_type is
--
l_rec g_rec_type;
l_rec.event_update_id := p_event_update_id;