DBA Data[Home] [Help]

APPS.GL_DAILY_RATES_PKG dependencies on FND_CURRENCIES

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

1026: -- This procedure is created for Ispeed Daily Rates API.
1027: -- It validate the following:
1028: -- o From_Currency and To_Currency are not the same
1029: -- o From_Currency and To_Currency:
1030: -- a. Currency exists in the FND_CURRENCIES table
1031: -- b. Currency is enabled
1032: -- c. Currency is not out of date
1033: -- d. Currency is not an EMU currency
1034: -- o Range of dates specified does not exceed 366 days

Line 1062: FROM FND_CURRENCIES

1058:
1059: ) IS
1060: CURSOR check_from_currency IS
1061: SELECT 'X'
1062: FROM FND_CURRENCIES
1063: WHERE currency_code = X_FROM_CURRENCY
1064: AND currency_flag = 'Y'
1065: AND enabled_flag ='Y'
1066: AND sign(trunc(sysdate) -

Line 1074: FROM FND_CURRENCIES

1070: AND decode(derive_type, 'EMU', sign( trunc(derive_effective) - trunc(X_CONVERSION_DATE)),1) > 0;
1071:
1072: CURSOR check_to_currency IS
1073: SELECT 'X'
1074: FROM FND_CURRENCIES
1075: WHERE currency_code = X_TO_CURRENCY
1076: AND currency_flag = 'Y'
1077: AND enabled_flag ='Y'
1078: AND sign(trunc(sysdate) -