APPS.OKC_CURRENCY_API dependencies on FND_CURRENCIES

Line 416: -- Get currency information from FND_CURRENCIES table

412: x_mau IN OUT NOCOPY NUMBER,
413: x_currency_type IN OUT NOCOPY VARCHAR2 ) IS
414:
415: BEGIN
416: -- Get currency information from FND_CURRENCIES table
417: SELECT decode( derive_type,
418: 'EURO', 'EURO',
419: 'EMU', decode( sign( trunc(p_eff_date) - trunc(derive_effective)),
420: -1, 'OTHER', 'EMU'),

Line 428: FROM FND_CURRENCIES

424: 'EMU', derive_factor,
425: 'OTHER', -1 ),
426: nvl( minimum_accountable_unit, power( 10, (-1 * precision)))
427: INTO x_currency_type, x_conversion_rate, x_mau
428: FROM FND_CURRENCIES
429: WHERE currency_code = p_currency;
430:
431:
432: EXCEPTION

Line 452: -- Get currency information from FND_CURRENCIES table

448: IS
449: l_currency_type varchar2(10);
450:
451: BEGIN
452: -- Get currency information from FND_CURRENCIES table
453:
454: SELECT decode( derive_type,
455: 'EURO', 'EURO',
456: 'EMU', decode( sign( trunc(p_eff_date) - trunc(derive_effective)),

Line 460: FROM FND_CURRENCIES

456: 'EMU', decode( sign( trunc(p_eff_date) - trunc(derive_effective)),
457: -1, 'OTHER', 'EMU'),
458: 'OTHER' )
459: INTO l_currency_type
460: FROM FND_CURRENCIES
461: WHERE currency_code = p_currency;
462:
463: Return l_currency_type;
464: