APPS.CSI_TRANSACTION_IMPORT_PVT dependencies on DUAL

Line 57: FROM dual;

53: BEGIN
54:
55: SELECT csi_batch_txn_lines_s.nextval
56: INTO l_seq
57: FROM dual;
58:
59: OPEN l_header_cur;
60: FETCH l_header_cur BULK COLLECT INTO l_header_id LIMIT 100*p_num_workers;
61: CLOSE l_header_cur;

Line 86: FROM dual;

82: l_seq_incr := p_num_workers;
83: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.CSI_BATCH_TXN_LINES_S INCREMENT BY '||TO_CHAR(l_seq_incr);
84: SELECT csi_batch_txn_lines_s.nextval
85: INTO l_seq
86: FROM dual;
87: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.CSI_BATCH_TXN_LINES_S INCREMENT BY 1';
88:
89: debug(' New Sequence Value '||l_seq);
90: end if;