APPS.JE_IL_TAX_PKG dependencies on AP_INVOICES

Line 182: ap_invoices ai

178: CURSOR c_get_invwht_check (cn_invoice_id NUMBER) IS
179: SELECT ai.invoice_id invoice_id
180: FROM ap_invoice_payments aip,
181: ap_invoice_distributions aid,
182: ap_invoices ai
183: WHERE ai.invoice_id = cn_invoice_id
184: AND ai.invoice_id = aip.invoice_id
185: AND aip.invoice_id = aid.invoice_id
186: AND aid.line_type_lookup_code = 'AWT'

Line 280: FROM ap_invoices WHERE invoice_id = ln_invoice_id;

276: END;
277: ln_gross_amount := ln_gross_amount * ln_sign;
278: BEGIN
279: SELECT invoice_type_lookup_code INTO lv_invoice_type
280: FROM ap_invoices WHERE invoice_id = ln_invoice_id;
281: EXCEPTION
282: WHEN others THEN
283: lv_invoice_type := 'STANDARD';
284: END;