DBA Data[Home] [Help]

APPS.ARP_ETAX_UTIL dependencies on RA_TERMS_LINES_DISCOUNTS

Line 3694: returns max(percentage) from ra_terms_lines_discounts

3690: END IF;
3691: END calc_applied_and_remaining;
3692:
3693: /* PUBLIC FUNCTION get_discount_rate
3694: returns max(percentage) from ra_terms_lines_discounts
3695: for use in transaction tax calculations. Note that the
3696: discount is /100 to make it ready for direct use in
3697: calculations.
3698: */

Line 3712: from ra_terms_lines_discounts tld,

3708: g_trx_id_for_disc := p_trx_id;
3709:
3710: select max(nvl(tld.discount_percent/100,0))
3711: into g_rate_for_disc
3712: from ra_terms_lines_discounts tld,
3713: ra_customer_trx trx
3714: where trx.customer_trx_id = p_trx_id
3715: and trx.term_id = tld.term_id (+);
3716: