APPS.HZ_IMP_LOAD_STAGE2 dependencies on DUAL

Line 182: SELECT hz_imp_errors_s.NEXTVAL INTO l_start_error_id FROM dual;

178: l_dml_record.DSS_SECURITY := P_DSS_SECURITY;
179: l_dml_record.ALLOW_DISABLED_LOOKUP := P_ALLOW_DISABLED_LOOKUP;
180: l_dml_record.PROFILE_VERSION := P_PROFILE_VERSION;
181: -- get the start error_id sequence number
182: SELECT hz_imp_errors_s.NEXTVAL INTO l_start_error_id FROM dual;
183:
184: -- check if staging table has data
185: l_what_if_sg_data_exists := HZ_IMP_LOAD_WRAPPER.STAGING_DATA_EXISTS(P_BATCH_ID, P_BATCH_MODE_FLAG, 2);
186:

Line 193: SELECT hz_imp_errors_s.CURRVAL INTO l_current_error_id FROM dual;

189: -- get the start error_id sequence number
190: -- if NO. of errors >= Error Limit, worker should not pick the next WU
191:
192: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: check for error limit');
193: SELECT hz_imp_errors_s.CURRVAL INTO l_current_error_id FROM dual;
194:
195: -- if estimated error is greater than error limit
196: IF l_current_error_id - l_start_error_id >= l_dml_record.ERROR_LIMIT AND
197: l_dml_record.OS IS NOT NUll THEN