SELECT ... FROM TABLE(My_CURSOR('param1', 'param2') ) t1 WHERE ...;

CREATE TABLE MASTER_TABLE   
(   "ID" NUMBER NOT NULL ENABLE, 
    "TYPE" VARCHAR2(2 BYTE) NOT NULL ENABLE, 
    "OPEN_DATE" DATE NOT NULL ENABLE, 
     CONSTRAINT "MASTER_TABLE_PK" PRIMARY KEY ("ID")
);
/ 
CREATE TABLE DETAILS_TABLE
(   "MASTER_ID" NUMBER NOT NULL ENABLE, 
    "DETAIL_TYPE" VARCHAR2(2 BYTE) NOT NULL ENABLE, 
    "MONEY" NUMBER(10,2) NOT NULL ENABLE, 
    "ACTIVE_FROM" DATE NOT NULL ENABLE, 
    "ACTIVE_TO" DATE
   );
/
CREATE INDEX DETAILS_TABLE_I1 ON DETAILS_TABLE (MASTER_ID) ;
 /
CREATE INDEX DETAILS_TABLE_I2 ON DETAILS_TABLE (DETAIL_TYPE) 
/

CREATE OR REPLACE PACKAGE test AS
    CURSOR D1_CURSOR(byDate DATE) IS 
        SELECT d.master_id, SUM(d.money) AS DETAIL1
        FROM DETAILS_TABLE d
        WHERE d.master_id = master_id
          AND d.detail_type = 'd1' 
          AND d.active_from <= byDate  
          AND ( d.active_to > byDate OR d.active_to IS NULL) 
        GROUP BY d.master_id;
 
    CURSOR D2_CURSOR(byDate DATE) IS 
        SELECT d.master_id, SUM(d.money) AS DETAIL2
        FROM DETAILS_TABLE d
        WHERE d.master_id = master_id
          AND d.detail_type = 'd2' 
          AND d.active_from <= byDate  
          AND ( d.active_to > byDate OR d.active_to IS NULL) 
        GROUP BY d.master_id ;
END test;
/
show errors PACKAGE test ;
/
 
CREATE OR REPLACE PACKAGE BODY test AS
END test;
/
 
show errors PACKAGE test ;
/

SELECT * FROM TABLE(test.D1_CURSOR(SYSDATE)) d1 WHERE d1.master_id = 1

SELECT m.id, m.TYPE, d1.DETAIL1, d2.DETAIL2
FROM MASTER_TABLE m, TABLE(D1_CURSOR(SYSDATE)) d1, TABLE(D2_CURSOR(SYSDATE)) d2,
WHERE m.id = d1.master_id AND m.id=d2.master_id

CURSOR REPORT_CURSOR IS
  SELECT m.id, m.TYPE, d1.DETAIL1, d2.DETAIL2
 
 FROM MASTER_TABLE m, TABLE(D1_CURSOR(SYSDATE)) d1, TABLE(D2_CURSOR(SYSDATE)) d2,
WHERE m.id = d1.master_id AND m.id=d2.master_id;