APPS.JAI_AP_STND_TAX_PROCESS dependencies on AP_INVOICES_ALL

Line 181: AP_INVOICES_ALL aila

177: CURSOR get_invoice_id_cur IS
178: SELECT
179: aila.invoice_id
180: FROM
181: AP_INVOICES_ALL aila
182: WHERE aila.invoice_id = pn_invoice_id
183: AND aila.INVOICE_NUM LIKE 'ITP-CM/%'
184: AND aila.description LIKE 'Credit Memo for inclusive 3rd party taxes for receipt%'
185: AND aila.SOURCE = 'INDIA TAX INVOICE'

Line 188: ln_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;

184: AND aila.description LIKE 'Credit Memo for inclusive 3rd party taxes for receipt%'
185: AND aila.SOURCE = 'INDIA TAX INVOICE'
186: AND aila.invoice_type_lookup_code ='CREDIT';
187:
188: ln_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;
189: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
190: ln_proc_level NUMBER := FND_LOG.level_procedure;
191: lv_proc_name VARCHAR2 (100) := 'Validate_3rd_party_cm_Invoice';
192: BEGIN

Line 2094: ap_invoices_all

2090: , invoice_currency_code
2091: , exchange_rate
2092: , batch_id
2093: FROM
2094: ap_invoices_all
2095: WHERE invoice_id = pn_invoice_id;
2096: BEGIN
2097: --log for debug
2098: IF ( ln_proc_level >= ln_dbg_level)

Line 2842: FROM ap_invoices_all

2838:
2839: -- Get the details of supplier id
2840: CURSOR jai_get_supplier_id (pn_invoice_id NUMBER) IS
2841: SELECT vendor_id
2842: FROM ap_invoices_all
2843: WHERE invoice_id = pn_invoice_id;
2844:
2845:
2846: -- Get the tax category_id of supplier id

Line 3363: AP_INVOICES_ALL

3359:
3360:
3361: /* Error msg will be populated AP Invoice workbench when changing the data in header
3362: UPDATE
3363: AP_INVOICES_ALL
3364: SET
3365: invoice_amount = (SELECT SUM(amount) FROM AP_INVOICE_LINES_ALL WHERE invoice_id =pn_invoice_id ),
3366: base_amount = (SELECT SUM(base_amount) FROM AP_INVOICE_LINES_ALL WHERE invoice_id =pn_invoice_id )
3367: WHERE invoice_id =pn_invoice_id;