DBA Data[Home] [Help]

APPS.XLA_JOURNAL_ENTRIES_PKG dependencies on FND_CURRENCIES

Line 5151: ,fnd_currencies fcu

5147: , xlr.ALC_DEFAULT_CONV_RATE_TYPE
5148: , xlr.ALC_INHERIT_CONVERSION_TYPE
5149: , decode(xlr.ALC_NO_RATE_ACTION_CODE, 'FIND_RATE', nvl(xlr.ALC_MAX_DAYS_ROLL_RATE, -1), 0) max_roll_days
5150: FROM xla_ledger_relationships_v xlr
5151: ,fnd_currencies fcu
5152: WHERE xlr.primary_ledger_id = p_info.ledger_id
5153: AND xlr.relationship_enabled_flag = 'Y'
5154: AND xlr.ledger_category_code = 'ALC'
5155: AND fcu.currency_code = xlr.currency_code;

Line 5169: , fnd_currencies fc

5165: , decode( fc2.derive_type, 'EURO', 'EURO', 'EMU',
5166: decode( sign( trunc(nvl(xal.currency_conversion_date, xal.accounting_date)) -
5167: trunc(fc2.derive_effective)), -1, 'OTHER', 'EMU'), 'OTHER' ) primary_type
5168: FROM xla_ae_lines xal
5169: , fnd_currencies fc
5170: , fnd_currencies fc1
5171: , fnd_currencies fc2
5172: WHERE xal.ae_header_id = p_info.header_id
5173: AND xal.application_id = p_info.application_id

Line 5170: , fnd_currencies fc1

5166: decode( sign( trunc(nvl(xal.currency_conversion_date, xal.accounting_date)) -
5167: trunc(fc2.derive_effective)), -1, 'OTHER', 'EMU'), 'OTHER' ) primary_type
5168: FROM xla_ae_lines xal
5169: , fnd_currencies fc
5170: , fnd_currencies fc1
5171: , fnd_currencies fc2
5172: WHERE xal.ae_header_id = p_info.header_id
5173: AND xal.application_id = p_info.application_id
5174: AND fc.currency_code = xal.currency_code

Line 5171: , fnd_currencies fc2

5167: trunc(fc2.derive_effective)), -1, 'OTHER', 'EMU'), 'OTHER' ) primary_type
5168: FROM xla_ae_lines xal
5169: , fnd_currencies fc
5170: , fnd_currencies fc1
5171: , fnd_currencies fc2
5172: WHERE xal.ae_header_id = p_info.header_id
5173: AND xal.application_id = p_info.application_id
5174: AND fc.currency_code = xal.currency_code
5175: AND fc1.currency_code = p_mrc_currency

Line 6140: FROM fnd_currencies

6136: ,decode(minimum_accountable_unit, NULL,
6137: round(p_amount, precision),
6138: round(p_amount/minimum_accountable_unit) * minimum_accountable_unit))
6139: INTO l_rounded_amount
6140: FROM fnd_currencies
6141: WHERE currency_code = p_currency_code;
6142:
6143: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6144: trace(p_msg => 'currency_code = '||p_currency_code,