APPS.HZ_BATCH_DUPLICATE dependencies on HZ_DL_SELECTED_CRITERIA

Line 170: insert into hz_dl_selected_criteria

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
173: where batch_id=l_batch_id and batch_type='SDIB');
174:

Line 171: (select hz_dl_selected_criteria_s.NEXTVAL, 'SDIB', l_new_batch_id, attribute_name,operation,value,fnd_global.user_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
173: where batch_id=l_batch_id and batch_type='SDIB');
174:
175: select dup_batch_name into l_batch_name from hz_dup_batch where dup_batch_id = l_batch_id;

Line 172: sysdate,fnd_global.login_id,fnd_global.user_id,sysdate from hz_dl_selected_criteria

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
173: where batch_id=l_batch_id and batch_type='SDIB');
174:
175: select dup_batch_name into l_batch_name from hz_dup_batch where dup_batch_id = l_batch_id;
176: