APPS.PA_AP_VAL_PKG SQL Statements

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

Line: 32

select 1 from pa_deductions_all
where not exists
(select 1 from ap_invoices_all
 where source = 'Oracle Project Accounting'
  AND    invoice_type_lookup_code = 'DEBIT'
  AND    product_table='PA_DEDUCTIONS_ALL'
  and deduction_req_id = to_number(reference_key1))
  and (vendor_id, project_id) in (select inv.vendor_id, apd.project_id
  from ap_invoices_all inv, ap_invoice_distributions_all apd
  where inv.invoice_id =p_invoice_id
  and inv.invoice_id=apd.invoice_id);