When Button Pressed select query issue

Hi Team

I have designed one basic form, which displays the basic information.

Post this, I designed one text item and added one find button, such that if user enters that text field, it display information for value enters in text field.

In my find button , i written a logic by writing an anonymous block , which fetch cursor records into text item.

Now all done, but my compilation of when button pressed is got failed. You can find small line near to select  at very first line.

Seems,  It is having issue with select statement written for sub queries.

If i comment 1st select statement, it goes to next select statement and gives same error.