SQL> CREATE TABLE pv_invoice_details (
  2      inv_id          NUMBER
  3  ,   charge_item_id  NUMBER
  4  ,   sett_date       DATE
  5  ,   to_date         DATE
  6  );
  
Table created.
  
SQL> INSERT INTO pv_invoice_details VALUES (1,101,TO_DATE('20030101','YYYYMMDD'),TO_DATE('20031231','YYYYMMDD'));
SQL> INSERT INTO pv_invoice_details VALUES (2,102,TO_DATE('20000904','YYYYMMDD'),TO_DATE(NULL));
SQL> INSERT INTO pv_invoice_details VALUES (3,103,TO_DATE('20020228','YYYYMMDD'),TO_DATE(NULL));
SQL> INSERT INTO pv_invoice_details VALUES (4,104,TO_DATE('20021001','YYYYMMDD'),TO_DATE('20040101','YYYYMMDD'));
SQL> CREATE TABLE pv_chargeable_items (
  2      charge_item_id      NUMBER
  3  ,   chargeable_item     VARCHAR2(1)
  4  ,   eff_date            DATE
  5  );
  
Table created.
  
SQL> INSERT INTO pv_chargeable_items VALUES (101,'Y',TO_DATE('20030630','YYYYMMDD'));
SQL> INSERT INTO pv_chargeable_items VALUES (103,'N',TO_DATE('19990731','YYYYMMDD'));
SQL> INSERT INTO pv_chargeable_items VALUES (104,'N',TO_DATE('20030815','YYYYMMDD'));
SQL> COMMIT;
  
Commit complete.
  
SQL> SELECT pid.inv_id
  2  ,      pci.chargeable_item
  3  FROM   pv_invoice_details pid
  4  ,      pv_chargeable_items pci
  5  WHERE  pid.charge_item_id = pci.charge_item_id (+)
  6  AND    pci.eff_date <font color=red><b>(+)</b></font> BETWEEN pid.sett_date
  7                              AND NVL(pid.to_date
  8                                  ,   TO_DATE('20991231'
  9                                      ,       'YYYYMMDD'))
 10  /
  
    INV_ID C
---------- -
         1 Y
         2
         3
         4 N
  
SQL>