APPS.GHR_PDH_SHD SQL Statements

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

Line: 55

  select  pd_routing_history_id,
  position_description_id,
  initiator_flag,
  requester_flag,
  approver_flag,
  reviewer_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,
  action_taken,
  groupbox_id,
  routing_list_id,
  routing_seq_number,
  date_notification_sent,
  object_version_number,
  item_key  from	ghr_pd_routing_history
    where	pd_routing_history_id = p_pd_routing_history_id;

Line: 144

    select
	pd_routing_history_id,
	position_description_id,
	initiator_flag,
        requester_flag,
	approver_flag,
	reviewer_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,
	action_taken,
	groupbox_id,
	routing_list_id,
      routing_seq_number,
 	date_notification_sent,
	object_version_number,
        item_key
    from	ghr_pd_routing_history
    where	pd_routing_history_id = p_pd_routing_history_id
    for	update nowait;