DBA Data[Home] [Help]

APPS.XLA_JOURNAL_ENTRIES_PKG dependencies on FND_CURRENCIES

Line 5347: ,fnd_currencies fcu

5343: , xlr.ALC_DEFAULT_CONV_RATE_TYPE
5344: , xlr.ALC_INHERIT_CONVERSION_TYPE
5345: , decode(xlr.ALC_NO_RATE_ACTION_CODE, 'FIND_RATE', nvl(xlr.ALC_MAX_DAYS_ROLL_RATE, -1), 0) max_roll_days
5346: FROM xla_ledger_relationships_v xlr
5347: ,fnd_currencies fcu
5348: WHERE xlr.primary_ledger_id = p_info.ledger_id
5349: AND xlr.relationship_enabled_flag = 'Y'
5350: AND xlr.ledger_category_code = 'ALC'
5351: AND fcu.currency_code = xlr.currency_code;

Line 5365: , fnd_currencies fc

5361: , decode( fc2.derive_type, 'EURO', 'EURO', 'EMU',
5362: decode( sign( trunc(nvl(xal.currency_conversion_date, xal.accounting_date)) -
5363: trunc(fc2.derive_effective)), -1, 'OTHER', 'EMU'), 'OTHER' ) primary_type
5364: FROM xla_ae_lines xal
5365: , fnd_currencies fc
5366: , fnd_currencies fc1
5367: , fnd_currencies fc2
5368: WHERE xal.ae_header_id = p_info.header_id
5369: AND xal.application_id = p_info.application_id

Line 5366: , fnd_currencies fc1

5362: decode( sign( trunc(nvl(xal.currency_conversion_date, xal.accounting_date)) -
5363: trunc(fc2.derive_effective)), -1, 'OTHER', 'EMU'), 'OTHER' ) primary_type
5364: FROM xla_ae_lines xal
5365: , fnd_currencies fc
5366: , fnd_currencies fc1
5367: , fnd_currencies fc2
5368: WHERE xal.ae_header_id = p_info.header_id
5369: AND xal.application_id = p_info.application_id
5370: AND fc.currency_code = xal.currency_code

Line 5367: , fnd_currencies fc2

5363: trunc(fc2.derive_effective)), -1, 'OTHER', 'EMU'), 'OTHER' ) primary_type
5364: FROM xla_ae_lines xal
5365: , fnd_currencies fc
5366: , fnd_currencies fc1
5367: , fnd_currencies fc2
5368: WHERE xal.ae_header_id = p_info.header_id
5369: AND xal.application_id = p_info.application_id
5370: AND fc.currency_code = xal.currency_code
5371: AND fc1.currency_code = p_mrc_currency

Line 6359: FROM fnd_currencies

6355: ,decode(minimum_accountable_unit, NULL,
6356: round(p_amount, precision),
6357: round(p_amount/minimum_accountable_unit) * minimum_accountable_unit))
6358: INTO l_rounded_amount
6359: FROM fnd_currencies
6360: WHERE currency_code = p_currency_code;
6361:
6362: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6363: trace(p_msg => 'currency_code = '||p_currency_code,