DBA Data[Home] [Help]

APPS.PA_AP_VAL_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 40: from ap_invoices_all inv, ap_invoice_distributions_all apd

36: AND invoice_type_lookup_code = 'DEBIT'
37: AND product_table='PA_DEDUCTIONS_ALL'
38: and deduction_req_id = to_number(reference_key1))
39: and (vendor_id, project_id) in (select inv.vendor_id, apd.project_id
40: from ap_invoices_all inv, ap_invoice_distributions_all apd
41: where inv.invoice_id =p_invoice_id
42: and inv.invoice_id=apd.invoice_id);
43:
44: