CREATE OR REPLACE PACKAGE MYPKG AS


CURSOR CUR(PDATE DATE DEFAULT NULL) IS
 WITH CL1 as
    
    (
      select .....
        from table (MYPKG.F_MYFUN(TO_DATE('09-JAN-2018','DD-MON-YYYY')) ) -- USING THE FUNCTION HERE 
    
      );
           
     TYPE CUR_type IS TABLE OF CUR%ROWTYPE;      
           
           FUNCTION F_MYFUN
        (PDATE DATE DEFAULT NULL)
    RETURN CUR_type PIPELINED;

END MYPKG;

  TYPE CUR_type IS TABLE OF CUR%ROWTYPE;