APPS.PQH_TXH_SHD SQL Statements

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

Line: 47

    select
       transaction_history_id
      ,creator_person_id
      ,assignment_id
      ,selected_person_id
      ,item_type
      ,item_key
      ,process_name
      ,approval_item_type
      ,approval_item_key
      ,function_id
      ,rptg_grp_id
      ,plan_id
      ,transaction_group
      ,transaction_identifier
    from        pqh_ss_transaction_history
    where       transaction_history_id = p_transaction_history_id;

Line: 118

    select
       transaction_history_id
      ,creator_person_id
      ,assignment_id
      ,selected_person_id
      ,item_type
      ,item_key
      ,process_name
      ,approval_item_type
      ,approval_item_key
      ,function_id
      ,rptg_grp_id
      ,plan_id
      ,transaction_group
      ,transaction_identifier
    from        pqh_ss_transaction_history
    where       transaction_history_id = p_transaction_history_id
    for update nowait;

Line: 183

  ,p_selected_person_id             in number
  ,p_item_type                      in varchar2
  ,p_item_key                       in varchar2
  ,p_process_name                   in varchar2
  ,p_approval_item_type             in varchar2
  ,p_approval_item_key              in varchar2
  ,p_function_id                    in number
  ,p_rptg_grp_id                    in number
  ,p_plan_id                        in number
  ,p_transaction_group              in varchar2
  ,p_transaction_identifier         in varchar2
  )
  Return g_rec_type is
--
  l_rec   g_rec_type;

Line: 206

  l_rec.selected_person_id               := p_selected_person_id;