APPS.HZ_BATCH_DUPLICATE dependencies on HZ_DUP_BATCH_S

Line 168: select HZ_DUP_BATCH_S.NEXTVAL into l_new_batch_id from dual;

164: select nvl(automerge_flag,'N') into l_automerge_flag
165: from hz_dup_batch
166: where dup_batch_id = l_batch_id;
167:
168: select HZ_DUP_BATCH_S.NEXTVAL into l_new_batch_id from dual;
169:
170: insert into hz_dl_selected_criteria
171: (select hz_dl_selected_criteria_s.NEXTVAL, 'SDIB', l_new_batch_id, attribute_name,operation,value,fnd_global.user_id,
172: sysdate,fnd_global.login_id,fnd_global.user_id,sysdate from hz_dl_selected_criteria

Line 191: UPDATE HZ_DUP_BATCH set automerge_flag = l_automerge_flag, last_update_date = SYSDATE,

187: 'SYSTEM_GENERATED',fnd_global.user_id,sysdate,fnd_global.login_id,
188: sysdate,fnd_global.user_id);
189:
190:
191: UPDATE HZ_DUP_BATCH set automerge_flag = l_automerge_flag, last_update_date = SYSDATE,
192: last_update_login = FND_GLOBAL.LOGIN_ID,last_updated_by = FND_GLOBAL.USER_ID
193: Where dup_batch_id = l_batch_id;
194: outandlog('new batch id = '||l_batch_id);
195: end if;