APPS.ICX_AP_INVOICES_PKG SQL Statements

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

Line: 18

         SELECT DISTINCT(ph.segment1)
         FROM   ap_invoice_distributions aid,
                po_distributions_ap_v    pd,
                po_headers               ph
         WHERE  aid.invoice_id         = l_invoice_id
         AND    aid.po_distribution_id = pd.po_distribution_id
         AND    pd.po_header_id        = ph.po_header_id;

Line: 57

         select (0 - sum(nvl(amount,0)))
         into   amount_withheld
         from   ap_invoice_distributions
         where  invoice_id = l_invoice_id
         and    line_type_lookup_code = 'AWT';