APPS.GL_CURRENCY_API dependencies on FND_CURRENCIES

Line 38: -- Get currency information from FND_CURRENCIES table

34: x_mau IN OUT NOCOPY NUMBER,
35: x_currency_type IN OUT NOCOPY VARCHAR2 ) IS
36:
37: BEGIN
38: -- Get currency information from FND_CURRENCIES table
39: SELECT decode( derive_type,
40: 'EURO', 'EURO',
41: 'EMU', decode( sign( trunc(x_eff_date) -
42: trunc(derive_effective)),

Line 53: FROM FND_CURRENCIES

49: nvl( minimum_accountable_unit, power( 10, (-1 * precision)))
50: INTO x_currency_type,
51: x_conversion_rate,
52: x_mau
53: FROM FND_CURRENCIES
54: WHERE currency_code = x_currency;
55:
56: EXCEPTION
57: WHEN NO_DATA_FOUND THEN

Line 146: | EURO -> FRENCH FRANK fixed rate from the FND_CURRENCIES |

142: | |
143: | 1) Old Currency to French Franks |
144: | Old Currency -> New Currency from the GL_FIXED_CONV_RATES table |
145: | New Currency -> EURO from the GL_DAILY_RATES |
146: | EURO -> FRENCH FRANK fixed rate from the FND_CURRENCIES |
147: | |
148: | 2) USD to New Currency |
149: | USD -> New CURRENCY from the GL Daily Rates Table. |
150: | |

Line 614: -- select this currency code from fnd_currencies table because

610: -- get_euro_code
611: --
612: -- Purpose
613: -- Returns the currency code for the EURO currency. We need to
614: -- select this currency code from fnd_currencies table because
615: -- the currency code for EURO has not been fixed at this time.
616: --
617: -- History
618: -- 24-JUL-97 W Wong Created

Line 630: FROM FND_CURRENCIES

626: BEGIN
627: -- Get currency code of the EURO currency
628: SELECT currency_code
629: INTO euro_code
630: FROM FND_CURRENCIES
631: WHERE derive_type = 'EURO';
632:
633: return( euro_code );
634:

Line 1455: FROM fnd_currencies

1451: BEGIN
1452:
1453: SELECT derive_type, derive_effective
1454: INTO derive_type, derive_effective
1455: FROM fnd_currencies
1456: WHERE currency_code = curr_code;
1457:
1458: IF (derive_type IS NULL or
1459: derive_type = 'OTHER') THEN