DBA Data[Home] [Help]

APPS.AP_IMPORT_INVOICES_PKG dependencies on AP_PAYMENT_SCHEDULES

Line 3581: FROM ap_payment_schedules

3577:
3578:
3579: SELECT sum(nvl(amount_remaining,0))
3580: INTO l_inv_amount_unpaid
3581: FROM ap_payment_schedules
3582: WHERE invoice_id = l_base_invoice_id;
3583:
3584: IF (nvl(l_inv_amount_unpaid,0) < l_invoice_rec.prepay_apply_amount) THEN
3585: l_amount_to_apply := l_inv_amount_unpaid;

Line 3671: AP_PAYMENT_SCHEDULES_PKG.adjust_pay_schedule(

3667: --End Bug 8513242
3668:
3669: l_payment_status_flag := AP_INVOICES_UTILITY_PKG.get_payment_status (l_base_invoice_id);
3670:
3671: AP_PAYMENT_SCHEDULES_PKG.adjust_pay_schedule(
3672: X_invoice_id => l_base_invoice_id,
3673: X_invoice_amount => l_inv_hdr_amount + l_exclusive_tax_amount ,
3674: X_payment_status_flag => l_payment_status_flag,
3675: X_invoice_type_lookup_code => l_invoice_rec.invoice_type_lookup_code,