For example, in the current query need's to be able to substitute sydate by variable.
I would like to call the function something like: get_empnos2('10-sep-18')
CREATE OR REPLACE FUNCTION get_empnos2
RETURN SYS_REFCURSOR
IS
l_rc SYS_REFCURSOR;
BEGIN
OPEN l_rc
FOR select
next_day(sysday - (level - 1) * 7, 'SUN' ) + 1 - 14 BEGIN_OF_WEEK
,next_day(sysday - (level - 1) * 7, 'SUN' ) END_OF_WEEK
from dual
connect by level <= 3;
RETURN l_rc;
END;