APPS.EDR_FILES_PUB dependencies on DUAL

Line 122: FROM dual;

118: LocalExistsRecord c_get_exists%ROWTYPE;
119:
120: CURSOR c_get_seq_num IS
121: SELECT edr_files_b_s.nextval
122: FROM dual;
123: LocalSeqRecord c_get_seq_num%ROWTYPE;
124:
125: CURSOR c_get_event IS
126: SELECT a.file_name, b.name

Line 135: FROM dual;

131:
132: -- Used to get the next attached_document_id for a new attachment
133: CURSOR c_get_id IS
134: SELECT fnd_attached_documents_s.nextval
135: FROM dual;
136:
137: -- Used to check if the attribute is required in the flexfield
138: CURSOR c_get_flex1 IS
139: SELECT count(*)

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

328: --Set up the display name for the attachment
329: l_file_name := l_file_name ||'_v_'||p_version_label||l_extension;
330:
331: --Get the next sequence number for file_id
332: SELECT edr_files_b_s.nextval INTO l_file_id FROM dual;
333:
334: --Call private package to insert data into the tables
335: --the whole idea is that instead of inserting one row in edr_files_b/tl tables
336: -- we would have to insert a row in: