APPS.WSH_TRANSACTIONS_FORM_PKG SQL Statements

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

Line: 93

SELECT wth.document_type,wth.document_number,wth.orig_document_number,wth.document_direction,wth.transaction_status,wth.
       action_type,wth.entity_number,wth.entity_type,wth.trading_partner_id,wth.ecx_message_id,wth.
       event_name,wth.event_key,wth.internal_control_number,wth.item_type,wndi.client_code
FROM   WSH_TRANSACTIONS_HISTORY wth,
       WSH_NEW_DEL_INTERFACE wndi
WHERE  wth.transaction_id = P_transaction_id
AND    wth.entity_number = wndi.delivery_interface_id(+);

Line: 102

  IS select TRANSACTION_STATUS
  FROM wsh_transactions_history
  WHERE transaction_id = v_trx_id;