APPS.GMA_STANDARD dependencies on DUAL

Line 176: FROM dual;

172: LocalExistsRecord c_get_exists%ROWTYPE;
173:
174: CURSOR c_get_seq_num IS
175: SELECT edr_files_b_s.nextval
176: FROM dual;
177: LocalSeqRecord c_get_seq_num%ROWTYPE;
178:
179: CURSOR c_get_event IS
180: SELECT a.file_name, b.name

Line 189: FROM dual;

185:
186: /* Used to get the next attached_document_id for a new attachment SKARIMIS*/
187: CURSOR c_get_id IS
188: SELECT fnd_attached_documents_s.nextval
189: FROM dual;
190:
191: /* Used to check if the attribute is required in the flexfield */
192: CURSOR c_get_flex1 IS
193: SELECT count(*)

Line 394: SELECT edr_files_b_s.nextval INTO l_file_id FROM dual;

390: l_file_name := l_file_name ||'_v_'||p_version_label||l_extension;
391:
392: /* Get the next sequence number for file_id */
393: /* Fixed SKARIMIS */
394: SELECT edr_files_b_s.nextval INTO l_file_id FROM dual;
395:
396: /* Call private package to insert data into the tables */
397: --cj the whole idea is that instead of inserting one row in edr_files_b/tl tables
398: -- we would have to insert a row in: