DBA Data[Home] [Help]

APPS.OZF_UTILITY_PVT dependencies on FND_CURRENCIES_VL

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

3180: --========================================================================
3181: FUNCTION get_currency_name(p_currency_code IN VARCHAR2) RETURN VARCHAR2
3182: IS
3183: CURSOR C_CURR_NAME(p_currency_code VARCHAR2) IS
3184: SELECT name FROM fnd_currencies_vl WHERE currency_code = p_currency_code;
3185:
3186: l_currency_name fnd_currencies_vl.name%type;
3187:
3188: BEGIN

Line 3186: l_currency_name fnd_currencies_vl.name%type;

3182: IS
3183: CURSOR C_CURR_NAME(p_currency_code VARCHAR2) IS
3184: SELECT name FROM fnd_currencies_vl WHERE currency_code = p_currency_code;
3185:
3186: l_currency_name fnd_currencies_vl.name%type;
3187:
3188: BEGIN
3189: OPEN C_CURR_NAME(p_currency_code);
3190: FETCH C_CURR_NAME INTO l_currency_name;