DBA Data[Home] [Help]

APPS.AME_UTIL dependencies on FND_CURRENCIES_ACTIVE_V

Line 455: returnValue fnd_currencies_active_v.name%type;

451: raise;
452: return(null);
453: end getConfigVar;
454: function getCurrencyName(currencyCodeIn in varchar2) return varchar2 as
455: returnValue fnd_currencies_active_v.name%type;
456: begin
457: select name
458: into returnValue
459: from fnd_currencies_active_v

Line 459: from fnd_currencies_active_v

455: returnValue fnd_currencies_active_v.name%type;
456: begin
457: select name
458: into returnValue
459: from fnd_currencies_active_v
460: where currency_code = currencyCodeIn;
461: return(currencyCodeIn || ' (' || returnValue || ')');
462: exception
463: when others then

Line 1167: from fnd_currencies_active_v

1163: tempCount integer;
1164: begin
1165: select count(*)
1166: into tempCount
1167: from fnd_currencies_active_v
1168: where currency_code = currencyCodeIn;
1169: if(tempCount > 0) then
1170: return(true);
1171: end if;

Line 3097: from fnd_currencies_active_v;

3093: end getConversionTypes;
3094: procedure getCurrencyCodes(currencyCodesOut out nocopy ame_util.stringList) as
3095: cursor codeCursor is
3096: select currency_code
3097: from fnd_currencies_active_v;
3098: tempIndex integer;
3099: begin
3100: tempIndex := 1;
3101: for tempCurrencyCode in codeCursor loop

Line 3121: fnd_currencies_active_v

3117: select
3118: name,
3119: currency_code
3120: from
3121: fnd_currencies_active_v
3122: order by currency_code;
3123: tempIndex integer;
3124: begin
3125: tempIndex := 1;