DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on AP_INVOICES_ALL

Line 10200: l_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;

10196: l_project_id NUMBER(15);
10197: l_base_qv NUMBER;
10198: l_base_av NUMBER;
10199: l_period_year pa_bc_packets.period_year%type; --REL12
10200: l_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
10201: l_line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE;
10202:
10203: -- R12 AP lines uptake : Prepayment changes :Cursor to fetch AP related details.
10204: CURSOR C_ap_details (p_invoice_id NUMBER,

Line 11770: ap_invoices_all inv

11766: AND PayDIST.invoice_payment_id = p_sys_ref4
11767: AND EXISTS
11768: (SELECT 1
11769: FROM ap_invoice_payments Pay,
11770: ap_invoices_all inv
11771: WHERE pay.invoice_payment_id = p_sys_ref4
11772: AND pay.invoice_id = inv.invoice_id
11773: AND NVL(pay.exchange_rate,0) <> NVL(inv.exchange_rate,0));
11774: