How to Write Lookup Query in PL/SQL

How to simplify lookup query in PL/SQL explained. You can use both cursor and Associative array for this purpose.