APPS.FUN_TRX_PVT dependencies on FND_CURRENCIES

Line 1008: --Bug: 8712286. Get currency information from FND_CURRENCIES table

1004: Debug('IS_AUTO_BATCH_BALANCE(+)');
1005:
1006: x_return_status := FND_API.G_RET_STS_SUCCESS;
1007:
1008: --Bug: 8712286. Get currency information from FND_CURRENCIES table
1009: SELECT nvl( minimum_accountable_unit, power( 10, (-1 * precision)))
1010: INTO l_mau
1011: FROM FND_CURRENCIES
1012: WHERE currency_code = p_currency_code;

Line 1011: FROM FND_CURRENCIES

1007:
1008: --Bug: 8712286. Get currency information from FND_CURRENCIES table
1009: SELECT nvl( minimum_accountable_unit, power( 10, (-1 * precision)))
1010: INTO l_mau
1011: FROM FND_CURRENCIES
1012: WHERE currency_code = p_currency_code;
1013:
1014:
1015: -- Sum the transaction Amounts

Line 1117: FROM fnd_currencies_vl

1113: l_rate NUMBER;
1114:
1115: CURSOR currency_csr IS
1116: SELECT COUNT(*)
1117: FROM fnd_currencies_vl
1118: WHERE currency_code = p_curr_code
1119: AND enabled_flag = 'Y'
1120: AND nvl(start_date_active, p_trx_date) <= nvl(p_trx_date, sysdate)
1121: AND nvl(end_date_active, p_trx_date) >= nvl(p_trx_date, sysdate);

Line 4364: -- Get currency information from FND_CURRENCIES table

4360: l_init_dist_count := p_init_dist_tbl.count;
4361: l_dist_lines_count := p_dist_lines_tbl.count;
4362:
4363: l_currency_code := p_batch_rec.currency_code;
4364: -- Get currency information from FND_CURRENCIES table
4365: SELECT nvl( minimum_accountable_unit, power( 10, (-1 * precision)))
4366: INTO l_mau
4367: FROM FND_CURRENCIES
4368: WHERE currency_code = l_currency_code;

Line 4367: FROM FND_CURRENCIES

4363: l_currency_code := p_batch_rec.currency_code;
4364: -- Get currency information from FND_CURRENCIES table
4365: SELECT nvl( minimum_accountable_unit, power( 10, (-1 * precision)))
4366: INTO l_mau
4367: FROM FND_CURRENCIES
4368: WHERE currency_code = l_currency_code;
4369:
4370:
4371: -- Delete the distributions generated for the initiator

Line 4901: SELECT PRECISION INTO l_precision FROM fnd_currencies WHERE currency_code=l_currency_code;

4897: IS
4898: l_precision NUMBER;
4899: BEGIN
4900:
4901: SELECT PRECISION INTO l_precision FROM fnd_currencies WHERE currency_code=l_currency_code;
4902: RETURN l_precision;
4903: END;
4904:
4905: END FUN_TRX_PVT;