APPS.HZ_BATCH_DUPLICATE dependencies on DUAL

Line 126: EXECUTE IMMEDIATE 'SELECT HZ_MATCH_RULE_'||p_rule_id||'.check_staged_var from dual' INTO l_staged_var;

122:
123: -- Fix for bug 4736139, to display an error message and error out
124: -- if staging not being run/complete, before calling SDIB.
125:
126: EXECUTE IMMEDIATE 'SELECT HZ_MATCH_RULE_'||p_rule_id||'.check_staged_var from dual' INTO l_staged_var;
127:
128: IF l_staged_var='N' THEN
129: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
130: FND_MSG_PUB.ADD;

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