APPS.CST_EAMCOST_PUB dependencies on FND_CURRENCIES

Line 6900: from fnd_currencies fc

6896: round(direct_item_txn_rec.act_res_rate/fc.minimum_accountable_unit)
6897: *fc.minimum_accountable_unit)) / nvl(direct_item_txn_rec.currency_conversion_rate,1)
6898: into l_base_txn_value,
6899: l_txn_value
6900: from fnd_currencies fc
6901: where currency_code = direct_item_txn_rec.currency_code;
6902:
6903: else
6904: select decode(nvl(fc.minimum_accountable_unit,0),0,

Line 6914: from fnd_currencies fc

6910: round(direct_item_txn_rec.act_res_rate * direct_item_txn_rec.qty /fc.minimum_accountable_unit)
6911: *fc.minimum_accountable_unit)) / nvl(direct_item_txn_rec.currency_conversion_rate,1)
6912: into l_base_txn_value,
6913: l_txn_value
6914: from fnd_currencies fc
6915: where currency_code = direct_item_txn_rec.currency_code;
6916:
6917: end if;
6918: l_acct_line_type := 5;

Line 7373: from fnd_currencies

7369: decode(precision, null, p_base_txn_value, round(p_base_txn_value,precision)),
7370: 0, decode(precision, null, p_base_txn_value, round(p_base_txn_value,precision)),
7371: round(p_base_txn_value/minimum_accountable_unit) * minimum_accountable_unit)
7372: into l_base_txn_value
7373: from fnd_currencies
7374: where currency_code = l_func_currency;
7375: else
7376: l_stmt_num := 70;
7377: select decode(minimum_accountable_unit,null,

Line 7382: from fnd_currencies

7378: decode(precision, null, p_txn_value, round(p_txn_value,precision)),
7379: 0, decode(precision, null, p_txn_value, round(p_txn_value,precision)),
7380: round(p_txn_value/minimum_accountable_unit) * minimum_accountable_unit)
7381: into l_txn_value
7382: from fnd_currencies
7383: where currency_code = l_currency;
7384:
7385: l_stmt_num := 90;
7386: select decode(minimum_accountable_unit,null,

Line 7391: from fnd_currencies

7387: decode(precision, null, p_base_txn_value, round(p_base_txn_value,precision)),
7388: 0, decode(precision, null, p_base_txn_value, round(p_base_txn_value,precision)),
7389: round((p_base_txn_value)/minimum_accountable_unit) * minimum_accountable_unit)
7390: into l_base_txn_value
7391: from fnd_currencies
7392: where currency_code = l_func_currency;
7393: end if;
7394:
7395: END IF; /* p_acct_line_type = 15 */

Line 7535: fnd_currencies fc

7531: FROM wip_cost_txn_interface wcti,
7532: po_distributions_all pod,
7533: po_headers_all poh,
7534: rcv_transactions rt,
7535: fnd_currencies fc
7536: WHERE wcti.transaction_id = p_txn_id
7537: AND poh.po_header_id = wcti.po_header_id
7538: AND poh.po_header_id = pod.po_header_id
7539: AND poh.po_header_id = rt.po_header_id

Line 11299: FND_CURRENCIES

11295: l_curreny_code,
11296: l_min_acct_unit_doc,
11297: l_precision_doc
11298: FROM
11299: FND_CURRENCIES
11300: WHERE
11301: CURRENCY_CODE =l_rcv_event.currency_code;
11302: EXCEPTION
11303: WHEN NO_DATA_FOUND THEN

Line 11333: FND_CURRENCIES

11329: INTO
11330: l_min_acct_unit_func,
11331: l_precision_func
11332: FROM
11333: FND_CURRENCIES
11334: WHERE
11335: CURRENCY_CODE = l_curreny_code_func;
11336: debug(' l_min_acct_unit_func:'||l_min_acct_unit_func||';l_precision_func:'||l_precision_func);
11337: