DBA Data[Home] [Help]

APPS.FII_CURRENCY_API dependencies on GL_DAILY_CONVERSION_TYPES

Line 41: FROM gl_daily_conversion_types

37: user_conversion_type
38: into l_currency_code,
39: l_secondary_currency_code,
40: l_rate
41: FROM gl_daily_conversion_types
42: WHERE bis_common_parameters.get_currency_code is not null
43: AND bis_common_parameters.get_rate_type = conversion_type;
44:
45: -- bug 3887180: if primary not same as secondary, just display the code

Line 79: FROM gl_daily_conversion_types

75: user_conversion_type
76: into l_currency_code,
77: l_secondary_currency_code,
78: l_secondary_rate
79: FROM gl_daily_conversion_types
80: WHERE bis_common_parameters.get_secondary_currency_code is not null
81: AND bis_common_parameters.get_secondary_rate_type = conversion_type;
82:
83: -- bug 3887180: if secondary not same as primary, just display the code

Line 117: FROM gl_daily_conversion_types

113: if l_currency_code is not null then
114: SELECT user_conversion_type
115: into
116: l_rate
117: FROM gl_daily_conversion_types
118: WHERE conversion_type=fnd_profile.value('BIS_ANNUALIZED_RATE_TYPE');
119:
120: fnd_message.set_name('FII','FII_ANNUALIZED_CURR_DISP_NAME');
121: fnd_message.set_token('CURRENCY_CODE',l_currency_code,FALSE);