DBA Data[Home] [Help]

APPS.AP_AUTOSELECT_PKG dependencies on PO_VENDORS

Line 282: po_vendors pov,

278: ai.org_id
279: FROM /* ap_interest_periods, Bug#12835170 */
280: ap_invoices AI, --Bug6040657. Changed from ap_invoices_all to ap_invoices
281: ap_selected_invoices_all ASI,
282: po_vendors pov,
283: ap_system_parameters_all asp
284: WHERE ASI.checkrun_id = P_checkrun_id
285: AND ASP.auto_calculate_interest_flag = 'Y'
286: AND ASP.org_id = asi.org_id

Line 332: l_int_vendor_name po_vendors.vendor_name%TYPE;

328: l_int_invoice_days NUMBER;
329: l_int_invoice_no varchar2(50);
330: l_int_invoice_num VARCHAR2(50);
331: l_int_invoice_rate NUMBER;
332: l_int_vendor_name po_vendors.vendor_name%TYPE;
333: l_int_vendor_num VARCHAR2(30);
334: l_interest_ap_ccid number;
335: l_inv_curr_int_amt NUMBER;
336: l_invoice_currency_code VARCHAR2(15);