DBA Data[Home] [Help]

APPS.GL_DAILY_RATES_PKG dependencies on DUAL

Line 816: FROM dual D

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

Line 882: FROM dual

878:
879: BEGIN
880: SELECT nvl(max('Y'),'N')
881: INTO is_used
882: FROM dual
883: WHERE EXISTS (
884: SELECT 'found'
885: FROM GL_LEDGERS LGR, GL_LEDGER_RELATIONSHIPS REL
886: WHERE LGR.currency_code IN (X_From_Currency, X_To_Currency)

Line 1121: FROM dual;

1117:
1118: SELECT least(trunc(X_To_Conversion_DATE) -
1119: trunc(X_From_Conversion_Date), 367)
1120: into numDays
1121: FROM dual;
1122:
1123: IF (numDays = 367) THEN
1124: fnd_message.set_name('SQLGL', 'GL_GLXRTDLY_LARGERANGE');
1125: app_exception.raise_exception;