APPS.AP_IMPORT_INVOICES_PKG dependencies on AP_INVOICE_LINES_ALL

Line 3501: -- ap_invoice_lines_all table

3497: -- The big difference between this call here and the one done
3498: -- during the prepayment application is the source of the data.
3499: -- Here we will use the pl/sql tables populated during validation
3500: -- in the prepayment case, the API will select the lines from the
3501: -- ap_invoice_lines_all table
3502: --------------------------------------------------------------
3503: debug_info := '(Import_invoice 15.8a) calc_tax_during_import_flag = Y, Call calculate tax';
3504:
3505: IF AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y' THEN

Line 3652: FROM ap_invoice_lines_all ail

3648: IF (NVL(l_invoice_rec.add_tax_to_inv_amt_flag, 'N') = 'Y') THEN
3649:
3650: SELECT ai.invoice_amount,
3651: (SELECT NVL(SUM(NVL(ail.amount, 0)), 0)
3652: FROM ap_invoice_lines_all ail
3653: WHERE ail.invoice_id = l_base_invoice_id
3654: AND ail.line_type_lookup_code = 'TAX'
3655: --bug 12727643 start
3656: and (ail.PREPAY_INVOICE_ID is null or