select cs.scriptExecutionID
into
	 :failedApplicationID
from CitizenScriptInfo cs 
inner join IEGExecutionState ie 
on cs.scriptExecutionID = ie.executionID 
where cs.scripttype = 'OST04' and cs.status != 'CSS03' and ie.scriptCompleted = '1'