APPS.ZX_MIGRATE_UTIL dependencies on DUAL

Line 327: EXECUTE IMMEDIATE 'SELECT '||p_seq_name||'.nextval from dual ' INTO seq_id;

323: seq_id number;
324:
325: begin
326:
327: EXECUTE IMMEDIATE 'SELECT '||p_seq_name||'.nextval from dual ' INTO seq_id;
328:
329: return seq_id;
330:
331: end get_next_seqid;

Line 363: FROM DUAL;

359: SELECT decode(sign(AP_TAX_CODES_S.nextval - AR_VAT_TAX_S.nextval),
360: '-1',AR_VAT_TAX_S.currval,
361: AP_TAX_CODES_S.currval)
362: INTO l_new_seq_id
363: FROM DUAL;
364:
365:
366: EXECUTE IMMEDIATE 'DROP SEQUENCE ZX.ZX_RATES_B_S';
367: EXECUTE IMMEDIATE 'CREATE SEQUENCE ZX.ZX_RATES_B_S START WITH '||l_new_seq_id;