[Home] [Help]
1562: round(p_amount * (percent_distribution/100) * nvl(p_exchange_rate,1)
1563: / arp_global.base_precision) * arp_global.base_precision
1564: ) acctd_amount
1565: FROM
1566: ar_distribution_set_lines
1567: WHERE
1568: distribution_set_id = p_distribution_set_id;
1569:
1570: CURSOR c_hist IS
1717: ),0)
1718:
1719: INTO l_rounding_diff,
1720: l_acctd_rounding_diff
1721: FROM ar_distribution_set_lines
1722: WHERE distribution_set_id = p_distribution_set_id;
1723:
1724: arp_util.debug('Rounding error = ' || to_char(l_rounding_diff));
1725: arp_util.debug('Rounding error (acctd) = ' || to_char(l_acctd_rounding_diff));