CREATE OR REPLACE PROCEDURE get_route_times(route IN VARCHAR2, day IN VARCHAR2,
refcursor OUT sys_refcursor)
AS
cursorSend  sys_refcursor;
BEGIN

    OPEN cursorSend FOR
SELECT RS.ROUTE_NO, RS.DIRECTION, RS.STOP_NAME, RS.JOURNEY_TIME, -- (ERROR 1 HERE)
    CASE
      WHEN lower(day)='sat' THEN to_char(trunc(sysdate-1/24, 'HH')+RS.JOURNEY_TIME/1440, 'HH24:MI')
      WHEN lower(day)='sun' THEN to_char(trunc(sysdate-1/24, 'HH')+RS.JOURNEY_TIME/1440, 'HH24:MI')
      ELSE to_char(trunc(sysdate-1/24, 'HH')+RS.JOURNEY_TIME/1440, 'HH24:MI')
    END AS "1",
    CASE
      WHEN lower(day)='sat' THEN to_char(trunc(sysdate-1/24, 'HH') + sat.Frequency +       RS.JOURNEY_TIME/1440, 'HH24:MI')
       WHEN lower(day)='sun' THEN to_char(trunc(sysdate-1/24, 'HH') + sun.Frequency + RS.JOURNEY_TIME/1440, 'HH24:MI')
        ELSE to_char(trunc(sysdate-1/24, 'HH')+week.Frequency + RS.JOURNEY_TIME/1440, 'HH24:MI')
      END AS "2",
    CASE
      WHEN lower(day)='sat' THEN to_char(trunc(sysdate-1/24, 'HH') + sat.Frequency*2 + RS.JOURNEY_TIME/1440, 'HH24:MI')
       WHEN lower(day)='sun' THEN to_char(trunc(sysdate-1/24, 'HH') + sun.Frequency*2 + RS.JOURNEY_TIME/1440, 'HH24:MI')
        ELSE to_char(trunc(sysdate-1/24, 'HH')+week.Frequency*2 + RS.JOURNEY_TIME/1440, 'HH24:MI')
      END AS "3",
          CASE
WHEN lower(day)='sat' THEN to_char(trunc(sysdate-1/24, 'HH') + sat.Frequency*3 + RS.JOURNEY_TIME/1440, 'HH24:MI')
WHEN lower(day)='sun' THEN to_char(trunc(sysdate-1/24, 'HH') + sun.Frequency*3 + RS.JOURNEY_TIME/1440, 'HH24:MI') -- ERROR 2 on this line
        ELSE to_char(trunc(sysdate-1/24, 'HH')+week.Frequency*3 + RS.JOURNEY_TIME/1440, 'HH24:MI')
      END AS "4"


     FROM BBT_ROUTESTOP RS
     INNER JOIN SATFREQ sat
     ON RS.ROUTE_NO = sat.ROUTE
     INNER JOIN SUNFREQ sun
     ON RS.ROUTE_NO = sun.ROUTE
     INNER JOIN WEEKFREQ week
      ON RS.ROUTE_NO = week.ROUTE
      WHERE lower(RS.ROUTE_NO)=lower(route)
      Order by RS.DIRECTION ASC;

      refcursor := cursorSend;
    END;