This image illustrates that you create a report with the
SELECT statement in the ref cursor query of the report. It also shows that
you can store the SELECT statement in a package in the database. Then,
from the report, you can call the package from the database allowing you
to reuse the package in many reports.