SQL subquery or PL/SQL

Hello folk,

The following SQL works but is inefficient because the subquery is repeated twice. I've tried a few different approaches using PL/SQL, but I only know enough PL/SQL to be a menace to society.

How do you avoid doing that subquery twice?

      from source_code_lst
      where seq + 5 >= 


           (select seq           


              from source_code_lst
              where location = &&LOC and loc_abs_rel = 'A')
         and seq - 5 <=                                       


           (select seq           


              from source_code_lst
              where location = &&LOC and loc_abs_rel = 'A')
      order by seq;

undefine LOC

Jeff Chamblee			      	"I'm not very smart, but 	
Computer Sciences Corp. 	      	I can lift heavy things."