DBA Data[Home] [Help]

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