APPS.HZ_AUTOMERGE_PKG dependencies on DUAL

Line 142: select hz_merge_batch_s.nextval into l_new_dup_set_id from dual;

138: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
139: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
140: END IF;
141: SAVEPOINT create_rem_batch;
142: select hz_merge_batch_s.nextval into l_new_dup_set_id from dual;
143: log (' Creating remainder batch....');
144: log (' l_new_dup_set_id = ' || l_new_dup_set_id);
145: -- log(' l_winner_party_id = ' || p_winner_party_id);
146: -- log (' s_dup_batch_id = ' || p_new_dup_batch_id);

Line 375: select hz_dup_batch_s.nextval into l_new_dup_batch_id from dual;

371: END IF;
372:
373: IF (( l_count > 0) AND (is_first))THEN
374: is_first := false;
375: select hz_dup_batch_s.nextval into l_new_dup_batch_id from dual;
376: log (' l_new_dup_batch_id = '|| l_new_dup_batch_id);
377: -- substring of dup_batch_name as this gets appended and inserted in same column. This way we avoid insertion errors.
378:
379: insert into hz_dup_batch(dup_batch_id, dup_batch_name, match_rule_id, request_type,