APPS.HR_CURRENCY_PKG dependencies on GL_DAILY_CONVERSION_TYPES

Line 182: -- checks that rate type exists in gl_daily_conversion_types

178: -- |------------------------< check_rate_type >-----------------------------|
179: -- --------------------------------------------------------------------------
180: --
181: -- Purpose
182: -- checks that rate type exists in gl_daily_conversion_types
183: --
184: -- returns -2 if User rate (which we won't to disallow)
185: -- -1 if rate type not found
186: -- 1 if record exists

Line 196: l_conversion_type gl_daily_conversion_types.conversion_type%type;

192: -- p_rate_type The rate type to check
193: --
194: Function check_rate_type(
195: p_rate_type VARCHAR2) RETURN NUMBER IS
196: l_conversion_type gl_daily_conversion_types.conversion_type%type;
197: l_return_count NUMBER;
198: BEGIN
199: --
200: select conversion_type

Line 202: from gl_daily_conversion_types

198: BEGIN
199: --
200: select conversion_type
201: into l_conversion_type
202: from gl_daily_conversion_types
203: where user_conversion_type = p_rate_type;
204: --
205: if l_conversion_type = 'User' then
206: l_return_count := -2;

Line 274: from gl_daily_conversion_types

270: -- we want to return the conversion_type, hence:
271: --
272: select conversion_type
273: into l_conversion_type
274: from gl_daily_conversion_types
275: where user_conversion_type = l_value;
276: --
277: return l_conversion_type;
278: --