DBA Data[Home] [Help]

APPS.AP_INVOICES_POST_PROCESS_PKG dependencies on AP_INVOICE_LINES

Line 310: from ap_invoice_lines

306: and hold_flag = 'Y';
307:
308: select count(*)
309: into X_Line_count
310: from ap_invoice_lines
311: where invoice_id = X_invoice_id;
312:
313: select sum(amount)
314: into X_Line_total

Line 315: from ap_invoice_lines

311: where invoice_id = X_invoice_id;
312:
313: select sum(amount)
314: into X_Line_total
315: from ap_invoice_lines
316: where invoice_id = X_invoice_id;
317:
318: EXCEPTION
319: WHEN OTHERS THEN

Line 650: FROM ap_invoice_lines -- bug 9255550

646: -- bug 2663549 amount_remaining should be adjusted for AWT amount
647: -- after payment_schedule has been recreated.
648: SELECT sum( nvl(amount, 0) )
649: INTO l_awt_amount
650: FROM ap_invoice_lines -- bug 9255550
651: WHERE invoice_id = X_invoice_id
652: AND line_type_lookup_code = 'AWT';
653:
654: SELECT sum(nvl(amount_remaining,0)), sum(nvl(gross_amount,0))