DBA Data[Home] [Help]

APPS.PA_AR_TRX_PURGE SQL Statements

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

Line: 7

    SELECT r.name
    INTO   flex_context
    FROM   ra_batch_sources r,
           pa_implementations p
    WHERE  p.invoice_batch_source_id = r.batch_source_id;
Line: 24

          select 'x'
          from dual
          where exists (
                        select 'x'
                        from  pa_draft_invoices di
                        where di.system_reference = p_customer_trx_id
                       );