DBA Data[Home] [Help]

APPS.OZF_UTILITY_PVT dependencies on FND_CURRENCIES_VL

Line 3206: SELECT name FROM fnd_currencies_vl WHERE currency_code = p_currency_code;

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

Line 3208: l_currency_name fnd_currencies_vl.name%type;

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;