APPS.WSH_SHIPMENT_REQUEST_PUB dependencies on DUAL

Line 403: SELECT to_char(p_date1,'YYYY/MM/DD HH24:MI:SS'),to_char(p_date2,'YYYY/MM/DD HH24:MI:SS') FROM DUAL;

399: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
400: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Process_Shipment_Requests';
401: --
402: CURSOR c_get_date(p_date1 DATE,p_date2 DATE) IS
403: SELECT to_char(p_date1,'YYYY/MM/DD HH24:MI:SS'),to_char(p_date2,'YYYY/MM/DD HH24:MI:SS') FROM DUAL;
404:
405: l_from_date VARCHAR2(100);
406: l_to_date VARCHAR2(100);
407: --