DBA Data[Home] [Help]

APPS.XLA_ACCOUNTING_CACHE_PKG dependencies on FND_CURRENCIES

Line 425: ,fnd_currencies fcu

421: ,fnd_id_flex_structures_tl fst
422: ,fnd_id_flex_structures_vl fsv
423: ,xla_acctg_methods_tl amt
424: ,xla_acctg_methods_vl amv
425: ,fnd_currencies fcu
426: ,fnd_languages fla
427: ,gl_coa_mappings gcm
428: WHERE xso.application_id = p_application_id
429: AND xso.relationship_enabled_flag = 'Y'

Line 487: ,fnd_currencies fcu

483: ,decode(xlr.ALC_NO_RATE_ACTION_CODE, 'FIND_RATE', nvl(xlr.ALC_MAX_DAYS_ROLL_RATE, -1), 0)
484: ALC_MAX_DAYS_ROLL_RATE
485: ,l.ROUNDING_CODE_COMBINATION_ID ROUNDING_CODE_COMBINATION_ID -- added for bug14522783
486: FROM xla_ledger_relationships_v xlr
487: ,fnd_currencies fcu
488: -- the following is added for bug 4640689
489: ,xla_subledgers xsl
490: ,gl_ledgers l -- 14522783
491: WHERE xlr.primary_ledger_id = p_base_ledger_id

Line 521: ,fnd_currencies fcu

517: ALC_MAX_DAYS_ROLL_RATE
518: ,glg.ROUNDING_CODE_COMBINATION_ID ROUNDING_CODE_COMBINATION_ID -- added for bug14522783
519: FROM gl_ledger_relationships glr
520: ,gl_ledgers glg
521: ,fnd_currencies fcu
522: ,xla_subledgers xsl
523: WHERE glr.primary_ledger_id = p_base_ledger_id
524: AND glr.relationship_enabled_flag = 'Y'
525: AND glg.ledger_category_code = 'ALC'

Line 657: ,fnd_currencies fcu

653: ,fnd_id_flex_structures_tl fst
654: ,fnd_id_flex_structures_vl fsv
655: ,xla_acctg_methods_tl amt
656: ,xla_acctg_methods_vl amv
657: ,fnd_currencies fcu
658: ,fnd_languages fla
659: ,gl_coa_mappings gcm
660: WHERE xso.application_id = p_application_id
661: AND xso.relationship_enabled_flag = 'Y'

Line 3228: FROM FND_CURRENCIES

3224:
3225: BEGIN --bug9590326
3226: SELECT nvl(minimum_accountable_unit, power(10, -1* precision))
3227: INTO l_entered_currency_mau.currency_mau
3228: FROM FND_CURRENCIES
3229: WHERE currency_code = p_currency_code;
3230:
3231: EXCEPTION WHEN NO_DATA_FOUND THEN
3232: l_entered_currency_mau.currency_mau := NULL;