APPS.PQH_TAH_SHD SQL Statements

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

Line: 48

    select
       approval_history_id
      ,transaction_history_id
      ,transaction_effective_date
      ,action
      ,user_name
      ,transaction_item_type
      ,transaction_item_key
      ,effective_date_option
      ,orig_system
      ,orig_system_id
      ,notification_id
      ,user_comment
    from        pqh_ss_approval_history
    where
        approval_history_id = p_approval_history_id
    and transaction_history_id = p_transaction_history_id;

Line: 123

    select
       approval_history_id
      ,transaction_history_id
      ,transaction_effective_date
      ,action
      ,user_name
      ,transaction_item_type
      ,transaction_item_key
      ,effective_date_option
      ,orig_system
      ,orig_system_id
      ,notification_id
      ,user_comment
    from        pqh_ss_approval_history
    where
    approval_history_id = p_approval_history_id
    and   transaction_history_id = p_transaction_history_id
    for update nowait;