SELECT SC_BASE_APPT.CALL_ID, SC_BASE_APPT.STATUS 
FROM SC_BASE_APPT , SC_BASE_INFO 
WHERE ( (SC_BASE_INFO.TRANS_ID = SC_BASE_APPT.TRANS_ID) )
AND SC_BASE_APPT.SC_ID = ? AND
((to_number(SC_BASE_INFO.AP_START) <= ? AND to_number(SC_BASE_INFO.AP_END) >= ?)
OR
(to_number(SC_BASE_INFO.AP_START) <= ? AND to_number(SC_BASE_INFO.AP_END) >= ?))