1402: NULL,round(l_ae_line_rec.transaction_value,c2.precision),
1403: round(l_ae_line_rec.transaction_value/c2.minimum_accountable_unit)
1404: * c2.minimum_accountable_unit )
1405: INTO l_ae_line_rec.transaction_value
1406: FROM fnd_currencies c2
1407: WHERE c2.currency_code = decode(l_curr_rec.alt_currency, NULL,
1408: l_curr_rec.pri_currency,
1409: l_curr_rec.alt_currency);
1410:
1464: NULL,round(l_ae_line_rec.transaction_value,c2.precision),
1465: round(l_ae_line_rec.transaction_value/c2.minimum_accountable_unit)
1466: * c2.minimum_accountable_unit )
1467: INTO l_ae_line_rec.transaction_value
1468: FROM fnd_currencies c2
1469: WHERE c2.currency_code = decode(l_curr_rec.alt_currency, NULL,
1470: l_curr_rec.pri_currency,
1471: l_curr_rec.alt_currency);
1472:
1517: NULL,round(l_ae_line_rec.transaction_value,c2.precision),
1518: round(l_ae_line_rec.transaction_value/c2.minimum_accountable_unit)
1519: * c2.minimum_accountable_unit )
1520: INTO l_ae_line_rec.transaction_value
1521: FROM fnd_currencies c2
1522: WHERE c2.currency_code = decode(l_curr_rec.alt_currency, NULL,
1523: l_curr_rec.pri_currency,
1524: l_curr_rec.alt_currency);
1525:
2759: l_current_accounted_value,
2760: l_prior_entered_value,
2761: l_prior_accounted_value
2762: from
2763: fnd_currencies c1,
2764: fnd_currencies c2
2765: where
2766: c1.currency_code = l_curr_rec.pri_currency
2767: and c2.currency_code = decode(l_curr_rec.alt_currency, NULL,
2760: l_prior_entered_value,
2761: l_prior_accounted_value
2762: from
2763: fnd_currencies c1,
2764: fnd_currencies c2
2765: where
2766: c1.currency_code = l_curr_rec.pri_currency
2767: and c2.currency_code = decode(l_curr_rec.alt_currency, NULL,
2768: l_curr_rec.pri_currency,
3628: into
3629: l_entered_value,
3630: l_accounted_value
3631: from
3632: fnd_currencies c1,
3633: fnd_currencies c2
3634: where
3635: c1.currency_code = i_ae_curr_rec.pri_currency
3636: and c2.currency_code = decode(i_ae_curr_rec.alt_currency, NULL,
3629: l_entered_value,
3630: l_accounted_value
3631: from
3632: fnd_currencies c1,
3633: fnd_currencies c2
3634: where
3635: c1.currency_code = i_ae_curr_rec.pri_currency
3636: and c2.currency_code = decode(i_ae_curr_rec.alt_currency, NULL,
3637: i_ae_curr_rec.pri_currency,