DBA Data[Home] [Help]

APPS.GL_JE_SOURCES_PKG dependencies on DUAL

Line 133: FROM sys.dual;

129:
130: FUNCTION get_unique_id RETURN NUMBER IS
131: CURSOR get_new_id IS
132: SELECT gl_je_sources_s.NEXTVAL
133: FROM sys.dual;
134: new_id number;
135: BEGIN
136: OPEN get_new_id;
137: FETCH get_new_id INTO new_id;

Line 205: CURSOR C2 IS SELECT gl_je_headers_s.nextval FROM dual;

201: CURSOR C IS SELECT rowid, language, source_lang
202: FROM GL_JE_SOURCES_TL
203: WHERE je_source_name = X_Je_Source_Name
204: and Language = userenv('LANG');
205: CURSOR C2 IS SELECT gl_je_headers_s.nextval FROM dual;
206: BEGIN
207:
208: if (X_Je_Source_Name is NULL) then
209: OPEN C2;