APPS.AP_IMPORT_INVOICES_PKG dependencies on AP_INVOICE_LINES_ALL

Line 2470: -- ap_invoice_lines_all table

2466: -- The big difference between this call here and the one done
2467: -- during the prepayment application is the source of the data.
2468: -- Here we will use the pl/sql tables populated during validation
2469: -- in the prepayment case, the API will select the lines from the
2470: -- ap_invoice_lines_all table
2471: --------------------------------------------------------------
2472: debug_info := '(Import_invoice 15.8a) Call calculate tax';
2473:
2474: IF AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y' THEN

Line 2596: FROM ap_invoice_lines_all ail

2592: IF (NVL(l_invoice_rec.add_tax_to_inv_amt_flag, 'N') = 'Y') THEN
2593:
2594: SELECT ai.invoice_amount,
2595: (SELECT NVL(SUM(NVL(ail.amount, 0)), 0)
2596: FROM ap_invoice_lines_all ail
2597: WHERE ail.invoice_id = l_base_invoice_id
2598: AND ail.line_type_lookup_code = 'TAX')
2599: INTO l_inv_hdr_amount, l_exclusive_tax_amount
2600: FROM ap_invoices_all ai