APPS.WSH_XC_PURGE_PKG dependencies on DUAL

Line 84: SELECT WSH_EXCEPTION_DEFINITIONS_S.nextval INTO l_sequence FROM SYS.DUAL ;

80: WSH_DEBUG_SV.push(l_module_name);
81: END IF;
82: --
83: LOOP
84: SELECT WSH_EXCEPTION_DEFINITIONS_S.nextval INTO l_sequence FROM SYS.DUAL ;
85: IF l_sequence > 1000 THEN
86: EXIT;
87: END IF;
88: END LOOP;

Line 99: SELECT WSH_EXCEPTION_DEFINITIONS_S.nextval INTO l_sequence FROM DUAL;

95: --
96: WSH_XC_UTIL.delete_xc_def_form(l_definition_rec.exception_definition_id);
97: IF l_definition_rec.update_allowed ='Y' THEN
98: -- customer data
99: SELECT WSH_EXCEPTION_DEFINITIONS_S.nextval INTO l_sequence FROM DUAL;
100: WSH_XC_UTIL.insert_xc_def_form (
101: x_exception_definition_id => l_sequence ,
102: p_exception_name => l_definition_rec.exception_name,
103: p_description => l_definition_rec.description,