The following lines contain the word 'select', 'insert', 'update' or 'delete':
select pa_routing_history_id,
pa_request_id,
attachment_modified_flag,
initiator_flag,
approver_flag,
reviewer_flag,
requester_flag,
authorizer_flag,
personnelist_flag,
approved_flag,
user_name,
user_name_employee_id ,
user_name_emp_first_name,
user_name_emp_last_name,
user_name_emp_middle_names,
notepad,
action_taken,
groupbox_id,
routing_list_id,
routing_seq_number,
noa_family_code,
nature_of_action_id,
second_nature_of_action_id,
approval_status,
date_notification_sent,
object_version_number from ghr_pa_routing_history
where pa_routing_history_id = p_pa_routing_history_id;
select pa_routing_history_id,
pa_request_id,
attachment_modified_flag,
initiator_flag,
approver_flag,
reviewer_flag,
requester_flag,
authorizer_flag,
personnelist_flag,
approved_flag,
user_name,
user_name_employee_id ,
user_name_emp_first_name,
user_name_emp_last_name,
user_name_emp_middle_names,
notepad,
action_taken,
groupbox_id,
routing_list_id,
routing_seq_number,
noa_family_code,
nature_of_action_id,
second_nature_of_action_id,
approval_Status,
date_notification_sent,
object_version_number
from ghr_pa_routing_history
where pa_routing_history_id = p_pa_routing_history_id
for update nowait;