APPS.IGS_SV_UTIL dependencies on DUAL

Line 267: --select igs_sv_batches_id_s.NEXTVAL into :i from dual;

263: /* ELSIF l_batch_rec.batch_status = 'X' THEN
264: l_batch_id := l_batch_rec.batch_id;
265: --*/
266: ELSE
267: --select igs_sv_batches_id_s.NEXTVAL into :i from dual;
268: l_batch_id := open_new_batch(p_person_id,p_batch_id,'HOLD');
269: END IF;
270:
271: -- my_dbg('Before First Cursor - l_batch_rec.batch_status : ', l_batch_rec.batch_status);

Line 418: SELECT igs_sv_batches_id_s.NEXTVAL INTO l_batch_id from dual;

414: OPEN batch_crsr (p_batch_id);
415: FETCH batch_crsr INTO l_batch_rec;
416: CLOSE batch_crsr;
417:
418: SELECT igs_sv_batches_id_s.NEXTVAL INTO l_batch_id from dual;
419:
420: INSERT INTO igs_sv_batches
421: (batch_id, schema_version,
422: sevis_user_id, sevis_school_id,