APPS.AR_TRANSFER_DOCUMENT SQL Statements

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

Line: 6

      select 'x' from ra_customer_trx where customer_trx_id = p_doc_rec.source_id;

Line: 33

      select 'x' from hz_party_sites where party_site_id = p_doc_rec.tp_source_id;

Line: 60

      select 'x' from wf_events where name = p_doc_rec.event_name and status = 'ENABLED' and type = 'EVENT';

Line: 86

    cursor ecxTrx is select 'x'
      from ecx_transactions trx,
           ecx_ext_processes proc,
           ecx_tp_headers tph,
           ecx_tp_details tpd
      where trx.transaction_type = p_doc_rec.ecx_trx_type and
            trx.transaction_subtype = p_doc_rec.ecx_trx_subtype and
            trx.party_type = p_doc_rec.ecx_party_type and
            proc.direction = 'OUT' and
            trx.transaction_id = proc.transaction_id and
            tph.party_type = p_doc_rec.ecx_party_type and
            tph.party_site_id = p_doc_rec.tp_source_id and
            tph.tp_header_id = tpd.tp_header_id and
            tpd.ext_process_id = proc.ext_process_id;

Line: 170

    select 'FND_RESP1:'||to_char(responsibility_id) role_name
    from fnd_responsibility_tl
    where application_id = 1;

Line: 231

      select * from ar_document_transfers where status = 'WAITING';

Line: 234

      select distinct exception_type from ar_document_transfers
      where status = 'FAILED';

Line: 258

        ar_document_transfer_pkg.updateRow(doc_rec);

Line: 304

    select exception_message from ar_document_transfers
    where exception_type = l_exception_type;

Line: 341

    select exception_message from ar_document_transfers
    where exception_type = l_exception_type;