DBA Data[Home] [Help]

APPS.GMF_GLCOMMON_DB dependencies on GL_CURR_MST

Line 29: FROM gl_curr_mst

25: error_status IN OUT NOCOPY NUMBER) RETURN NUMBER IS
26:
27: CURSOR C_get_euro_code IS
28: SELECT currency_code
29: FROM gl_curr_mst
30: WHERE derive_type = 1 and
31: delete_mark = 0;
32:
33:

Line 208: /* Get currency information from GL_CURR_MST table*/

204: x_currency_type IN OUT NOCOPY VARCHAR2,
205: error_status IN OUT NOCOPY NUMBER ) IS
206: BEGIN
207: error_status := 0;
208: /* Get currency information from GL_CURR_MST table*/
209: SELECT decode( derive_type,
210: 1, 'EURO',
211: 2, decode( sign( trunc(x_eff_date) -
212: trunc(derive_effective)),

Line 223: FROM gl_curr_mst

219: nvl( decimal_precision, power( 10, (-1 * decimal_precision)))
220: INTO x_currency_type,
221: x_exchange_rate,
222: x_mau
223: FROM gl_curr_mst
224: WHERE currency_code = x_currency;
225: EXCEPTION
226: WHEN NO_DATA_FOUND THEN
227: error_status := 100;