DBA Data[Home] [Help]

APPS.AP_AUTOSELECT_PKG dependencies on PO_VENDORS

Line 88: po_vendors pov,

84: ai.org_id
85: FROM ap_interest_periods,
86: ap_invoices AI, --Bug6040657. Changed from ap_invoices_all to ap_invoices
87: ap_selected_invoices_all ASI,
88: po_vendors pov,
89: ap_system_parameters_all asp
90: WHERE ASI.checkrun_id = P_checkrun_id
91: AND ASP.auto_calculate_interest_flag = 'Y'
92: AND ASP.org_id = asi.org_id

Line 138: l_int_vendor_name po_vendors.vendor_name%TYPE;

134: l_int_invoice_days NUMBER;
135: l_int_invoice_no varchar2(50);
136: l_int_invoice_num VARCHAR2(50);
137: l_int_invoice_rate NUMBER;
138: l_int_vendor_name po_vendors.vendor_name%TYPE;
139: l_int_vendor_num VARCHAR2(30);
140: l_interest_ap_ccid number;
141: l_inv_curr_int_amt NUMBER;
142: l_invoice_currency_code VARCHAR2(15);