3202: --========================================================================
3203: FUNCTION get_currency_name(p_currency_code IN VARCHAR2) RETURN VARCHAR2
3204: IS
3205: CURSOR C_CURR_NAME(p_currency_code VARCHAR2) IS
3206: SELECT name FROM fnd_currencies_vl WHERE currency_code = p_currency_code;
3207:
3208: l_currency_name fnd_currencies_vl.name%type;
3209:
3210: BEGIN
3204: IS
3205: CURSOR C_CURR_NAME(p_currency_code VARCHAR2) IS
3206: SELECT name FROM fnd_currencies_vl WHERE currency_code = p_currency_code;
3207:
3208: l_currency_name fnd_currencies_vl.name%type;
3209:
3210: BEGIN
3211: OPEN C_CURR_NAME(p_currency_code);
3212: FETCH C_CURR_NAME INTO l_currency_name;