336:
337: CURSOR currency_csr IS
338: SELECT name meaning
339: FROM fnd_currencies_active_v
340: WHERE currency_code = bis_common_parameters.get_currency_code;
341:
342: BEGIN
343:
344: -- Get currency name
346: FETCH currency_csr INTO l_currency_name;
347: CLOSE currency_csr;
348:
349: -- Get currency code and rate type
350: l_currency_code := bis_common_parameters.get_currency_code;
351: l_rate_type := bis_common_parameters.get_rate_type;
352:
353: l_sql_stmt :=
354: 'SELECT
347: CLOSE currency_csr;
348:
349: -- Get currency code and rate type
350: l_currency_code := bis_common_parameters.get_currency_code;
351: l_rate_type := bis_common_parameters.get_rate_type;
352:
353: l_sql_stmt :=
354: 'SELECT
355: per.full_name person