APPS.AP_APPROVAL_MATCHED_PKG dependencies on AP_INVOICES_ALL

Line 540: FROM AP_INVOICES_all ai

536:
537: --bug 9242891 select added to determine which cursor to open.
538: SELECT COUNT(*)
539: INTO l_cnt
540: FROM AP_INVOICES_all ai
541: WHERE ai.invoice_id = p_invoice_id
542: AND ai.invoice_type_lookup_code = 'RETAINAGE RELEASE';
543: --bug 9242891
544:

Line 2293: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

2289: l_cancelled_flag ap_invoice_lines.cancelled_flag%TYPE;
2290: l_matching_basis po_line_locations.matching_basis%TYPE; -- Amount Based Matching
2291:
2292: --Contract Payments: Tolerances Redesign
2293: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
2294: l_payment_type po_line_locations_all.payment_type%TYPE;
2295: l_billed_amt NUMBER;
2296: l_amt_delivered NUMBER;
2297: l_amt_corrected NUMBER;