APPS.AP_CALC_WITHHOLDING_PKG dependencies on AP_INVOICES_ALL

Line 2140: FROM ap_invoices_all

2136: invoice_number,
2137: supplier_id,
2138: supplier_site_id,
2139: g_org_id /* Bug 3700128. MOAC Project */
2140: FROM ap_invoices_all
2141: WHERE invoice_id = P_Invoice_Id;
2142:
2143: -- Get base currency code:
2144:

Line 2237: ap_invoices_all ai

2233: BEGIN
2234: SELECT glps.period_name
2235: INTO tab_max_gl_period(i)
2236: FROM gl_period_statuses glps,
2237: ap_invoices_all ai
2238: WHERE glps.application_id = 200
2239: AND nvl(glps.adjustment_period_flag, 'N') <>'Y'
2240: AND (
2241: (GLPS.closing_status IN ('O', 'F'))