sql - using a lookup table on a form with Oracle Apex Item -

i have application uses oracle apex 4.2 . has form ( form , report on table) needs display descriptions columns on table. instance, there column on table called fund has numeric value ( 1 6). there separate table gives description each of these 6 values. under edit page item, under source, chose source type -> sql query entered query below:

  select description     "#owner#"."bu19ant",    "#owner#"."fundcd"   antfundcd =  code 

where bu19ant table used form fundcd name of table antfundcd , code , numeric fields on respective tables , description value want , display on form.

this gives me correct answer of time, not time. key table ( , field used link report form) soc security number. if run same query against oracle table hard coding ss number, correct answer.

this form has 5 ups work way , have same problem. assume dont need include social security number part of query apex knows that.

but tried add , can not figure out how code it.
tried

  antsocialsecuritynumber ( column on table) = p2_socialsecuritynumber ( item on page) 

but gave error

ora-00904: "p2_socialsecuritynumber ": invalid identifier

is there other way code this? or ss number = current record? or on wrong track here?

try :p2_socialsecuritynumber (for items on session) or &p2_socialsecuritynumber. (for items on page)