DBA Data[Home] [Help]

APPS.ARP_ETAX_UTIL dependencies on RA_TERMS_LINES_DISCOUNTS

Line 3632: returns max(percentage) from ra_terms_lines_discounts

3628: END IF;
3629: END calc_applied_and_remaining;
3630:
3631: /* PUBLIC FUNCTION get_discount_rate
3632: returns max(percentage) from ra_terms_lines_discounts
3633: for use in transaction tax calculations. Note that the
3634: discount is /100 to make it ready for direct use in
3635: calculations.
3636: */

Line 3650: from ra_terms_lines_discounts tld,

3646: g_trx_id_for_disc := p_trx_id;
3647:
3648: select max(nvl(tld.discount_percent/100,0))
3649: into g_rate_for_disc
3650: from ra_terms_lines_discounts tld,
3651: ra_customer_trx trx
3652: where trx.customer_trx_id = p_trx_id
3653: and trx.term_id = tld.term_id (+);
3654: