APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on AP_PAYMENT_SCHEDULES

Line 4619: ap_payment_schedules apps

4615: INTO l_inv_exchange_rate,
4616: l_payment_cross_rate,
4617: l_payment_currency_code -- Bug 2886571
4618: FROM ap_invoices apin,
4619: ap_payment_schedules apps
4620: WHERE apin.invoice_id = l_invoice_id
4621: AND apps.invoice_id = l_invoice_id
4622: AND apps.payment_num = l_payment_num;
4623:

Line 4636: UPDATE ap_payment_schedules

4632: -- Bug 2886571 Rounding the amounts.
4633: --------------------------------------------------------
4634: -- Updates the amount remaining of the payment schedule
4635: --------------------------------------------------------
4636: UPDATE ap_payment_schedules
4637: SET amount_remaining = ap_utilities_pkg.ap_round_currency(
4638: amount_remaining - (l_withhold_amount * nvl(l_payment_cross_rate, 1)),
4639: l_payment_currency_code),
4640: payment_status_flag = decode( ap_utilities_pkg.ap_round_currency(amount_remaining -

Line 5784: ap_payment_schedules apps

5780: apps.payment_cross_rate
5781: INTO l_inv_exchange_rate,
5782: l_payment_cross_rate
5783: FROM ap_invoices apin,
5784: ap_payment_schedules apps
5785: WHERE apin.invoice_id = l_invoice_id
5786: AND apps.invoice_id = l_invoice_id
5787: AND apps.payment_num = l_payment_num;
5788:

Line 5799: UPDATE ap_payment_schedules

5795:
5796: --------------------------------------------------------
5797: -- Updates the amount remaining of the payment schedule
5798: --------------------------------------------------------
5799: UPDATE ap_payment_schedules
5800: SET amount_remaining = amount_remaining +
5801: (l_withhold_amount *
5802: nvl(l_payment_cross_rate, 1)),
5803: payment_status_flag = decode(amount_remaining +