Hi All,
I am trying to create stored procedures using inline subquery. when I run the query normally, but when the query is inserted into the cursor him get an error.
cursor cashoutin is
select name ,
(select sum(amount) from ar_cash_receipts_all ac, ar_receivables_trx_all ar
where ac.receivables_trx_id=ar.receivables_trx_id
and ac.set_of_books_id=glsb.set_of_books_id
and receipt_date between '01-MAR-14' and '31-MAR-14') kontribusi_prd,
from gl_sets_of_books glsb
where set_of_books_id > 470;
v_cashoutin cashoutin%rowtype;
can anybody help me
Thanks