One of my developers wrote this and I am trying to insert it into a package,
but I am getting a compile error:

PLS-00103: Encountered the symbol "SELECT" when expecting one of the
following:
( - + mod not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count c


The select by itself, works fine, can you please take a look and offer any
suggestions? I tried a GROUP BY function, but that didn't work
either..THanks!

procedure sp_Get_Load_data
(
i_employee_id IN s_employee.Employee_ID%type,
cur_Data OUT curResult
)

IS

begin
open cur_Data for

SELECT a.CURRBASESAL_MONAMT,
(SELECT MIN(WKAB)
FROM S_TCORE_ENUM_MAPPING WHERE FINEOS_ENUM = a.CURSALWAGEBAS
and DOMAIN = 'SalaryWageBasis') AS SalaryAmount
from s_tocperson a, s_tcoreoffsets b, s_tcoredeductions c,
s_tcorefinancialdata d
where a.I = (select i from s_tocperson where uniqueid = '153708612') and
b.I_OCPERS_OFFS = a.i and
c.I_OCPERS_DEDS = a.i and
d.I_OCPERS_FIND = a.i;

end sp_Get_Load_data;




****************************************************************
Please Note
The information in this E-mail message is legally privileged
and confidential information intended only for the use of the
individual(s) named above. If you, the reader of this message,
are not the intended recipient, you are hereby notified that
you should not further disseminate, distribute, or forward this
E-mail message. If you have received this E-mail in error,
please notify the sender. Thank you
*****************************************************************
Oracle LazyDBA home page