The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
absence_action_id
,absence_attendance_id
,expected_date
,description
,actual_start_date
,actual_end_date
,holder
,comments
,document_file_name
,last_updated_by
,object_version_number
,enabled
from per_nl_absence_actions
where absence_action_id = p_absence_action_id;
select
absence_action_id
,absence_attendance_id
,expected_date
,description
,actual_start_date
,actual_end_date
,holder
,comments
,document_file_name
,last_updated_by
,object_version_number
,enabled
from per_nl_absence_actions
where absence_action_id = p_absence_action_id
for update nowait;
,p_last_updated_by in number
,p_object_version_number in number
,p_enabled in varchar2
)
Return g_rec_type is
--
l_rec g_rec_type;
l_rec.last_updated_by := p_last_updated_by;