SQL & PL/SQL

SELECT
evt_code,
evt_mrc,
evt_completed,
evt_org,
evt_status,
evt_desc,
evt_object,
evt_jobtype,
evt_reopened,
R5REP.REPLABOUR(evt_code) as evt_labor,

obj_desc,
obj_obtype,
obj_status,
obj_production,
obj_criticality,

/*GET THE NUMBER OF SUNDAYS WITHIN THE SPECIFIED DATE RANGE*/
(select COUNT(*) from (
select to_char(to_date(#prompt('SEL_FDATE','date')#) + rownum - 1) as days
from all_objects
where rownum <= (to_date(#prompt('SEL_TDATE','date')#) - to_date(#prompt('SEL_FDATE','date')#)) + 1) s
where s.days='SUN') as NoS

FROM
r5events, r5objects
WHERE
evt_completed between #prompt('SEL_TDATE','date')# and #prompt('SEL_FDATE','date')#


Error:
QE-DEF-0374 Prompt 'SEL_FDATE' is used multiple times with conflicting data types.

Trace back:

WPBIBusMethod.cpp(190): WPDataRetrievalException: CCL_CAUGHT: WPBIBusMethod::run

WPReportExecutionMethod.cpp(174): WPDataRetrievalException: CCL_RETHROW: WPReportExecutionMethod::checkRequestForExceptions

WPExecuteRequestThread.cpp(169): WPDataRetrievalException: WPExecuteRequestThread::checkException

WPEngine.cpp(946): WPDataRetrievalException:

WPController.cpp(263): WPDataRetrievalException: CCL_RETHROW: WPController::executeRendering()

LWDataRetrievalEngine.cpp(304): WPDataRetrievalException: CCL_RETHROW: LWDataRetrievalEngine::prepare

LWDataRetrievalEngine.cpp(1803): WPDataRetrievalException: CCL_THROW: LWDataRetrievalEngine::runQSQuery

Source/QE_QsApi.cpp(3384): QSException: CCL_THROW: QE