280: l_log_msg := 'Get discount available for invoice_id:' ||
281: to_char(l_invoice_id) || ' payment_num:' ||
282: to_char(l_payment_num);
283:
284: SELECT ap_payment_schedules_pkg.get_discount_available(
285: invoice_id,
286: payment_num,
287: P_check_date,
288: P_currency_code)
313:
314: l_log_msg := 'Get discount available for invoice_id:' ||
315: to_char(l_invoice_id);
316:
317: SELECT SUM(ap_payment_schedules_pkg.get_discount_available(
318: invoice_id,
319: payment_num,
320: P_check_date,
321: P_currency_code))
389: --
390: CURSOR payments_cursor IS
391: SELECT payment_num,
392: amount_remaining,
393: ap_payment_schedules_pkg.get_discount_available(
394: invoice_id,
395: payment_num,
396: P_check_date,
397: P_currency_code)
697: AIRP.vendor_site_id,
698: AIRP.exclusive_payment_flag,
699: AIRP.accts_pay_code_combi_id,
700: AIRP.amount_remaining,
701: ap_payment_schedules_pkg.get_discount_available(
702: AIRP.invoice_id,
703: AIRP.payment_num,
704: P_check_date,
705: P_currency_code),