DBA Data[Home] [Help]

APPS.FUN_TRX_PVT dependencies on FND_CURRENCIES

Line 1056: FROM fnd_currencies_vl

1052: l_rate NUMBER;
1053:
1054: CURSOR currency_csr IS
1055: SELECT COUNT(*)
1056: FROM fnd_currencies_vl
1057: WHERE currency_code = p_curr_code
1058: AND enabled_flag = 'Y'
1059: AND nvl(start_date_active, p_trx_date) <= nvl(p_trx_date, sysdate)
1060: AND nvl(end_date_active, p_trx_date) >= nvl(p_trx_date, sysdate);

Line 4075: -- Get currency information from FND_CURRENCIES table

4071: l_init_dist_count := p_init_dist_tbl.count;
4072: l_dist_lines_count := p_dist_lines_tbl.count;
4073:
4074: l_currency_code := p_batch_rec.currency_code;
4075: -- Get currency information from FND_CURRENCIES table
4076: SELECT nvl( minimum_accountable_unit, power( 10, (-1 * precision)))
4077: INTO l_mau
4078: FROM FND_CURRENCIES
4079: WHERE currency_code = l_currency_code;

Line 4078: FROM FND_CURRENCIES

4074: l_currency_code := p_batch_rec.currency_code;
4075: -- Get currency information from FND_CURRENCIES table
4076: SELECT nvl( minimum_accountable_unit, power( 10, (-1 * precision)))
4077: INTO l_mau
4078: FROM FND_CURRENCIES
4079: WHERE currency_code = l_currency_code;
4080:
4081:
4082: -- Delete the distributions generated for the initiator