package to calculate cash discount from toad
Hi,
Please let me know, what is the package name to calculate cash discount from back end (Toad).
Tried with these packages.
1) SELECT apps.arp_discounts_api.get_available_disc_on_inv
(p_applied_payment_schedule_id => 980857,
p_apply_date => '21-APR-2017',
p_amount_to_be_applied => 10000
)
ln_discount_amt
FROM DUAL
2) apps.arp_discounts_api.get_discount
Both are not calculating, showing as 0.
Thanks in advance.
DK.