6532: round(direct_item_txn_rec.act_res_rate/fc.minimum_accountable_unit)
6533: *fc.minimum_accountable_unit)) / nvl(direct_item_txn_rec.currency_conversion_rate,1)
6534: into l_base_txn_value,
6535: l_txn_value
6536: from fnd_currencies fc
6537: where currency_code = direct_item_txn_rec.currency_code;
6538:
6539: else
6540: select decode(nvl(fc.minimum_accountable_unit,0),0,
6546: round(direct_item_txn_rec.act_res_rate * direct_item_txn_rec.qty /fc.minimum_accountable_unit)
6547: *fc.minimum_accountable_unit)) / nvl(direct_item_txn_rec.currency_conversion_rate,1)
6548: into l_base_txn_value,
6549: l_txn_value
6550: from fnd_currencies fc
6551: where currency_code = direct_item_txn_rec.currency_code;
6552:
6553: end if;
6554: l_acct_line_type := 5;
6934: decode(precision, null, p_base_txn_value, round(p_base_txn_value,precision)),
6935: 0, decode(precision, null, p_base_txn_value, round(p_base_txn_value,precision)),
6936: round(p_base_txn_value/minimum_accountable_unit) * minimum_accountable_unit)
6937: into l_base_txn_value
6938: from fnd_currencies
6939: where currency_code = l_func_currency;
6940: else
6941: l_stmt_num := 70;
6942: select decode(minimum_accountable_unit,null,
6943: decode(precision, null, p_txn_value, round(p_txn_value,precision)),
6944: 0, decode(precision, null, p_txn_value, round(p_txn_value,precision)),
6945: round(p_txn_value/minimum_accountable_unit) * minimum_accountable_unit)
6946: into l_txn_value
6947: from fnd_currencies
6948: where currency_code = l_currency;
6949:
6950: l_stmt_num := 90;
6951: select decode(minimum_accountable_unit,null,
6952: decode(precision, null, p_base_txn_value, round(p_base_txn_value,precision)),
6953: 0, decode(precision, null, p_base_txn_value, round(p_base_txn_value,precision)),
6954: round((p_base_txn_value)/minimum_accountable_unit) * minimum_accountable_unit)
6955: into l_base_txn_value
6956: from fnd_currencies
6957: where currency_code = l_func_currency;
6958: end if;
6959:
6960: if (l_debug = 'Y') then