APPS.AP_GET_SUPPLIER_BALANCE_PKG dependencies on AP_PAYMENT_SCHEDULES

Line 105: FROM ap_payment_schedules

101:
102: --3641604 : New cursor to get sum of discount available for invoice
103: CURSOR ps_cursor (p_invoice_id NUMBER) IS
104: SELECT payment_num
105: FROM ap_payment_schedules
106: WHERE invoice_id = p_invoice_id;
107:
108:
109: BEGIN --#1

Line 192: ap_payment_schedules_pkg.get_discount_available

188: FOR ps_rec IN ps_cursor(inv_rec.invoice_id)
189: LOOP
190: BEGIN
191: l_discount_avail := l_discount_avail +
192: ap_payment_schedules_pkg.get_discount_available
193: (inv_rec.invoice_id, ps_rec.payment_num, sysdate,
194: inv_rec.invoice_currency_code);
195: EXCEPTION
196: WHEN NO_DATA_FOUND THEN