DBA Data[Home] [Help]

APPS.AP_IMPORT_INVOICES_PKG dependencies on AP_PAYMENT_SCHEDULES

Line 2547: FROM ap_payment_schedules

2543:
2544:
2545: SELECT sum(nvl(amount_remaining,0))
2546: INTO l_inv_amount_unpaid
2547: FROM ap_payment_schedules
2548: WHERE invoice_id = l_base_invoice_id;
2549:
2550: IF (nvl(l_inv_amount_unpaid,0) < l_invoice_rec.prepay_apply_amount) THEN
2551: l_amount_to_apply := l_inv_amount_unpaid;

Line 2605: AP_PAYMENT_SCHEDULES_PKG.adjust_pay_schedule(

2601: WHERE ai.invoice_id = l_base_invoice_id;
2602:
2603: l_payment_status_flag := AP_INVOICES_UTILITY_PKG.get_payment_status (l_base_invoice_id);
2604:
2605: AP_PAYMENT_SCHEDULES_PKG.adjust_pay_schedule(
2606: X_invoice_id => l_base_invoice_id,
2607: X_invoice_amount => l_inv_hdr_amount + l_exclusive_tax_amount ,
2608: X_payment_status_flag => l_payment_status_flag,
2609: X_invoice_type_lookup_code => l_invoice_rec.invoice_type_lookup_code,