APPS.GL_DAILY_RATES_PKG dependencies on FND_CURRENCIES

Line 1044: -- a. Currency exists in the FND_CURRENCIES table

1040: -- This procedure is created for Ispeed Daily Rates API.
1041: -- It validate the following:
1042: -- o From_Currency and To_Currency are not the same
1043: -- o From_Currency and To_Currency:
1044: -- a. Currency exists in the FND_CURRENCIES table
1045: -- b. Currency is enabled
1046: -- c. Currency is not out of date
1047: -- d. Currency is not an EMU currency
1048: -- o Range of dates specified does not exceed 366 days

Line 1076: FROM FND_CURRENCIES

1072:
1073: ) IS
1074: CURSOR check_from_currency IS
1075: SELECT 'X'
1076: FROM FND_CURRENCIES
1077: WHERE currency_code = X_FROM_CURRENCY
1078: AND currency_flag = 'Y'
1079: AND enabled_flag ='Y'
1080: AND sign(trunc(sysdate) -

Line 1088: FROM FND_CURRENCIES

1084: AND decode(derive_type, 'EMU', sign( trunc(derive_effective) - trunc(X_CONVERSION_DATE)),1) > 0;
1085:
1086: CURSOR check_to_currency IS
1087: SELECT 'X'
1088: FROM FND_CURRENCIES
1089: WHERE currency_code = X_TO_CURRENCY
1090: AND currency_flag = 'Y'
1091: AND enabled_flag ='Y'
1092: AND sign(trunc(sysdate) -