DBA Data[Home] [Help]

APPS.GL_CRM_UTILITIES_PKG dependencies on FND_CURRENCIES

Line 481: -- a. Currency exists in the FND_CURRENCIES table

477: -- o Conversion_type exists,
478: -- o Conversion_rate is not a negative number
479: -- o Inverse_conversion_rate is not a negative number
480: -- o From_Currency and To_Currency:
481: -- a. Currency exists in the FND_CURRENCIES table
482: -- b. Currency is enabled
483: -- c. Currency is not a statistical currency
484: -- d. Currency is not out of date
485: -- e. Currency is not an EMU currency

Line 606: fnd_currencies from_curr,

602: 0, 'EMU_TO_CURRENCY',
603: ''))))))))))))))))))
604: FROM gl_daily_rates_interface ri2,
605: gl_daily_conversion_types ct,
606: fnd_currencies from_curr,
607: fnd_currencies to_curr
608: WHERE ri2.ROWID = ri.ROWID
609: AND ct.user_conversion_type(+) = ri2.user_conversion_type
610: AND from_curr.currency_code(+) = ri2.from_currency

Line 607: fnd_currencies to_curr

603: ''))))))))))))))))))
604: FROM gl_daily_rates_interface ri2,
605: gl_daily_conversion_types ct,
606: fnd_currencies from_curr,
607: fnd_currencies to_curr
608: WHERE ri2.ROWID = ri.ROWID
609: AND ct.user_conversion_type(+) = ri2.user_conversion_type
610: AND from_curr.currency_code(+) = ri2.from_currency
611: AND to_curr.currency_code(+) = ri2.to_currency),

Line 748: fnd_currencies from_curr,

744: 0, 'EMU_TO_CURRENCY',
745: ''))))))))))))))))))
746: FROM gl_daily_rates_interface ri2,
747: gl_daily_conversion_types ct,
748: fnd_currencies from_curr,
749: fnd_currencies to_curr
750: WHERE ri2.ROWID = ri.ROWID
751: AND ct.user_conversion_type(+) = ri2.user_conversion_type
752: AND from_curr.currency_code(+) = ri2.from_currency

Line 749: fnd_currencies to_curr

745: ''))))))))))))))))))
746: FROM gl_daily_rates_interface ri2,
747: gl_daily_conversion_types ct,
748: fnd_currencies from_curr,
749: fnd_currencies to_curr
750: WHERE ri2.ROWID = ri.ROWID
751: AND ct.user_conversion_type(+) = ri2.user_conversion_type
752: AND from_curr.currency_code(+) = ri2.from_currency
753: AND to_curr.currency_code(+) = ri2.to_currency)