APPS.ZX_MIGRATE_UTIL dependencies on DUAL

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

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

Line 365: FROM DUAL;

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