PL/SQL Loop help needed

This is my first attempt at PL/SQL.

1. I have a record, PSRECFIELD from which I can extract a list of all records in the Oracle 8i db that contain the field EMPLID. This can be gained by the SQL Select RECNAME from PSRECFIELD where FIELDNAME = 'EMPLID';
2. I need to then find which of those records contains an EMPLID of a specific value. For example, if selecting from a single table the SQL is Select EMPLID from PSTAB1 where EMPLID = '1234';
3. How do I set up the PL/SQL loop so that I can loop through all records returned in 1) to find and report only those records that have an EMPLID value of '1234' as in 2)??????