APPS.AP_WEB_AUDIT_UTILS dependencies on AP_INVOICE_LINES_ALL
Line 3076: FROM ap_invoice_lines_all ail,
3072: l_prepay_amount_remaining NUMBER := 0;
3073:
3074: CURSOR c_prepay_amount_remaining IS
3075: SELECT SUM(nvl(aid.prepay_amount_remaining,ail.amount)) 3076: FROM ap_invoice_lines_all ail, 3077: ap_invoice_distributions aid
3078: WHERE ail.invoice_id = P_invoice_id
3079: AND aid.invoice_id = ail.invoice_id
3080: AND aid.invoice_line_number = ail.line_number