APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on AP_PAYMENT_SCHEDULES

Line 4856: ap_payment_schedules apps

4852: INTO l_inv_exchange_rate,
4853: l_payment_cross_rate,
4854: l_payment_currency_code -- Bug 2886571
4855: FROM ap_invoices apin,
4856: ap_payment_schedules apps
4857: WHERE apin.invoice_id = l_invoice_id
4858: AND apps.invoice_id = l_invoice_id
4859: AND apps.payment_num = l_payment_num;
4860:

Line 4873: UPDATE ap_payment_schedules

4869: -- Bug 2886571 Rounding the amounts.
4870: --------------------------------------------------------
4871: -- Updates the amount remaining of the payment schedule
4872: --------------------------------------------------------
4873: UPDATE ap_payment_schedules
4874: SET amount_remaining = ap_utilities_pkg.ap_round_currency(
4875: amount_remaining - (l_withhold_amount * nvl(l_payment_cross_rate, 1)),
4876: l_payment_currency_code),
4877: payment_status_flag = decode( ap_utilities_pkg.ap_round_currency(amount_remaining -

Line 6115: ap_payment_schedules apps

6111: apps.payment_cross_rate
6112: INTO l_inv_exchange_rate,
6113: l_payment_cross_rate
6114: FROM ap_invoices apin,
6115: ap_payment_schedules apps
6116: WHERE apin.invoice_id = l_invoice_id
6117: AND apps.invoice_id = l_invoice_id
6118: AND apps.payment_num = l_payment_num;
6119:

Line 6130: UPDATE ap_payment_schedules

6126:
6127: --------------------------------------------------------
6128: -- Updates the amount remaining of the payment schedule
6129: --------------------------------------------------------
6130: UPDATE ap_payment_schedules
6131: SET amount_remaining = amount_remaining +
6132: (l_withhold_amount *
6133: nvl(l_payment_cross_rate, 1)),
6134: payment_status_flag = decode(amount_remaining +