APPS.OKL_ESG_TRANSPORT_PVT SQL Statements

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

Line: 19

    SELECT p.party_id, tp.tp_header_id, tp.party_site_id, tp.party_type
      FROM ecx_tp_headers tp
         , hz_parties p
     WHERE tp.party_id = p.party_id
       AND p.party_name = 'SuperTrump';

Line: 26

    SELECT t.ext_subtype, t.protocol_address, t.username, t.password,
           t.protocol_type   -- added bug8209104
      FROM ecx_tp_details_v t
         , okl_stream_interfaces si
     WHERE t.transaction_type = 'OKL_ST'
       AND t.transaction_subtype = si.deal_type
       AND si.transaction_number = b_transaction_number;

Line: 129

    INSERT INTO OKL_STREAM_TRX_DATA
    (id, transaction_number, out_xml)
    VALUES
    (p_transaction_number
    ,p_transaction_number
    ,p_xml
    );