APPS.PQH_TSH_SHD SQL Statements

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

Line: 48

    select
       transaction_history_id
      ,approval_history_id
      ,creator_person_id
      ,creator_role
      ,status
      ,transaction_state
      ,effective_date
      ,effective_date_option
      ,last_update_role
      ,parent_transaction_id
      ,relaunch_function
      ,transaction_document
    from        pqh_ss_trans_state_history
    where       transaction_history_id = p_transaction_history_id
    and   approval_history_id = p_approval_history_id;

Line: 122

    select
       transaction_history_id
      ,approval_history_id
      ,creator_person_id
      ,creator_role
      ,status
      ,transaction_state
      ,effective_date
      ,effective_date_option
      ,last_update_role
      ,parent_transaction_id
      ,relaunch_function
      ,transaction_document
    from        pqh_ss_trans_state_history
    where       transaction_history_id = p_transaction_history_id
    and   approval_history_id = p_approval_history_id
    for update nowait;

Line: 197

  ,p_last_update_role               in varchar2
  ,p_parent_transaction_id          in number
  ,p_relaunch_function              in varchar2
  ,p_transaction_document           in CLOB
  )
  Return g_rec_type is
--
  l_rec   g_rec_type;

Line: 218

  l_rec.last_update_role                 := p_last_update_role;