SQL & PL/SQL :: ORA-00942 Table Or View Does Not Exit

In this scenario(within procedure) 1st cursor return data but 2nd cursor showing error like ORA-00942: table or view does not exit.

declare
cursor r1 is
select table_name,table_partition_name
from abc
where table_partition_name like 'NORMAL_P%'
and base_table_name like 'NORMAL'
and date_column_name like 'C_DATE'
and to_date(to_char(from_date,'dd/mon/yyyy'),'dd/mon/yyyy') between '25-jun-2010' and '27-jun-2010'
order by substr(table_partition_name,19,4);
[code].....