APPS.HZ_IMP_LOAD_STAGE3 dependencies on DUAL

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

78: WHERE BATCH_ID = l_dml_record.BATCH_ID
79: AND REQUEST_ID = l_dml_record.REQUEST_ID;
80:
81: -- get the start error_id sequence number
82: SELECT hz_imp_errors_s.NEXTVAL INTO l_start_error_id FROM dual;
83:
84: LOOP
85:
86: -- get the start error_id sequence number

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

85:
86: -- get the start error_id sequence number
87: -- if NO. of errors >= Error Limit, worker should not pick the next WU
88:
89: SELECT hz_imp_errors_s.CURRVAL INTO l_current_error_id FROM dual;
90:
91: -- if estimated error is greater than error limit
92: IF l_current_error_id - l_start_error_id + l_orig_error_count >= l_dml_record.ERROR_LIMIT AND
93: l_dml_record.OS IS NOT NUll THEN