APPS.AP_APXAPRVL_XMLP_PKG SQL Statements

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

Line: 82

     SELECT batch_name
     INTO   c_batch_name
     FROM   ap_batches
     WHERE  batch_id = p_inv_batch_id;

Line: 102

   Select invoice_num
     into cp_invoice_number
     from ap_invoices
     where invoice_id = p_invoice_id;

Line: 123

   SELECT vendor_name
     INTO cp_supplier_name
     FROM po_vendors
    WHERE vendor_id = p_vendor_id;

Line: 266

   SELECT distinct accounting_date acc_date
     FROM ap_invoice_distributions
    WHERE invoice_id = p_invoice_id
          and NVL(match_status_flag,'N') = 'N';

Line: 271

   SELECT upper(nvl(source, 'X'))
     FROM ap_invoices
    WHERE invoice_id = p_invoice_id;

Line: 321

    Select user_name
    Into l_user_name
    From fnd_user
    Where user_id = p_entered_by;