DBA Data[Home] [Help]

APPS.GL_DAILY_RATES_PKG dependencies on DUAL

Line 817: FROM dual D

813: AND X_Conversion_Type IS NOT NULL ) THEN
814:
815: SELECT 1
816: INTO dummy
817: FROM dual D
818: WHERE NOT EXISTS ( SELECT 1
819: FROM GL_DAILY_RATES R
820: WHERE R.from_currency = X_From_Currency
821: AND R.to_currency = X_To_Currency

Line 896: FROM dual

892:
893: BEGIN
894: SELECT nvl(max('Y'),'N')
895: INTO is_used
896: FROM dual
897: WHERE EXISTS (
898: SELECT 'found'
899: FROM GL_LEDGERS LGR, GL_LEDGER_RELATIONSHIPS REL
900: WHERE LGR.currency_code IN (X_From_Currency, X_To_Currency)

Line 1135: FROM dual;

1131:
1132: SELECT least(trunc(X_To_Conversion_DATE) -
1133: trunc(X_From_Conversion_Date), 367)
1134: into numDays
1135: FROM dual;
1136:
1137: IF (numDays = 367) THEN
1138: fnd_message.set_name('SQLGL', 'GL_GLXRTDLY_LARGERANGE');
1139: app_exception.raise_exception;