APPS.AP_WEB_EXPORT_ER dependencies on AP_INVOICE_LINES_ALL

Line 2796: FROM ap_invoice_lines_all

2792: IF l_oie_applied_prepay_list(i) IS NOT NULL THEN
2793: BEGIN
2794: SELECT abs(sum(amount))
2795: INTO l_actual_adv_applied
2796: FROM ap_invoice_lines_all
2797: WHERE invoice_id = l_invoice_id_list(i)
2798: AND line_type_lookup_code = 'PREPAY'
2799: AND prepay_invoice_id = l_oie_applied_prepay_list(i);
2800: EXCEPTION

Line 2822: FROM ap_invoice_lines_all ap1

2818:
2819: BEGIN
2820: SELECT sum(amount)
2821: INTO l_inv_total_amount
2822: FROM ap_invoice_lines_all ap1
2823: WHERE invoice_id = l_invoice_id_list(i);
2824: EXCEPTION
2825: WHEN NO_DATA_FOUND THEN
2826: l_inv_total_amount :=-1;