APPS.GHR_PRH_SHD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 56

  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;

Line: 151

  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;