DBA Data[Home] [Help]

APPS.AP_APPROVAL_MATCHED_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1516: UPDATE ap_invoice_distributions_all aid

1512:
1513: l_qv_ratio := l_qv_upd/l_amount_upd;
1514: l_base_qv_ratio := l_base_qv_upd/l_base_amount_upd;
1515:
1516: UPDATE ap_invoice_distributions_all aid
1517: SET quantity_variance = ap_utilities_pkg.ap_round_currency
1518: (aid.amount * l_qv_ratio, p_inv_currency_code)
1519: ,base_quantity_variance = ap_utilities_pkg.ap_round_currency
1520: (aid.base_amount * l_base_qv_ratio, p_base_currency_code)

Line 1772: UPDATE ap_invoice_distributions_all aid

1768:
1769: l_av_ratio := l_av_upd/l_amount_upd;
1770: l_base_av_ratio := l_base_av_upd/l_base_amount_upd;
1771:
1772: UPDATE ap_invoice_distributions_all aid
1773: SET amount_variance = ap_utilities_pkg.ap_round_currency
1774: (aid.amount * l_av_ratio, p_inv_currency_code)
1775: ,base_amount_variance = ap_utilities_pkg.ap_round_currency
1776: (aid.base_amount * l_base_av_ratio, p_base_currency_code)