I am working on a stored procedure that deals with data from 2 different schemas (fnbaa and aafnbdbo). I am issuing the statement from aafnbbo. There are 2 tables in fnbaa (charge and charge_definition) and one in aafnbdbo (expcodes). The SELECT statment below works fine in SQL*Plus but when I try to save the stored procedure I get an error saying that: identifier FNBAA.CHARGE must be declared? Is there something I am missing as far as the syntax is concerned? See any glaring errors? As always, thanks!

	SELECT RTRIM(product_id) ExpCode, RTRIM(charge_name) ExpCodeName, RTRIM(charge_type) ChargeType
		FROM fnbaa.charge C, fnbaa.charge_definition CD
		WHERE c.charge_id=cd.charge_id AND
		RTRIM(product_id) IN
		(SELECT RTRIM(expcode) FROM aafnbdbo.expcodes WHERE RTRIM(source)=InSource)
		AND SUBSTR(cd.charge_id,INSTR(cd.charge_id,'-')+1,3)='STD';

P.S. "InSource" is a varchar2 input parameter to the stored procedure.