DBA Data[Home] [Help]

APPS.GMA_EDITTEXT_PKG dependencies on DUAL

Line 53: FROM DUAL;

49: IF dbms_sql.fetch_rows (l_Cursor) > 0 THEN
50:
51: -- Generate new Text_code from sequence.
52: SELECT gem5_text_code_s.nextval into l_New_Text_code
53: FROM DUAL;
54:
55: -- Main sql stmt which inserts all text lines, replacing text_code with sequence
56: l_TL_Sql_statement:= 'INSERT INTO '||X_To_Text_table||
57: ' ( '||