APEX

Hi, Guys:

I am new to APEX, and encounter a problem in my project. I was wondering if anyone could give me a hand on this issue:

I built a form page, and need to generate a report page according to what I input on the form page. The problem is: the data that I input such as first name through text field data entry cannot pass to the report page at all. Unless I set up a static value for the first name text field after button submitted, no value is passed to the report page. The query for the report page never returns data as search condition includes referring to value of first name text field data entry on the form page. Here is my query for the report page:

select so.offender_id, so.first_name, so.last_name, sl.address1, sl.address2, sl.city, sl.county, sl.state, sl.status
from sor_location sl, sor_offender so
where sl.offender_id=so.offender_id
and sl.status='Verified'
and so.first_name=:P21_TF_FIRST_NAME
and sl.entry_date=(select max(sl.entry_date)
from sor_location sl2
where sl2.status='Verified'
and sl2.offender_id=sl.offender_id
)

If I change :P21_TF_FIRST_NAME with any static value, the report works fine.

Could anyone help me on this problem?

Thanks a lot in advance!