DBA Data[Home] [Help]

APPS.CST_EAMCOST_PUB dependencies on FND_CURRENCIES

Line 6536: from fnd_currencies fc

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,

Line 6550: from fnd_currencies fc

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;

Line 6938: from fnd_currencies

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,

Line 6947: from fnd_currencies

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,

Line 6956: from fnd_currencies

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