select scriptexecutionid
into
	:failedLifeEventID
from lifeevent le 
inner join (
	select cs.datastoreid, cs.scriptexecutionid 
	from CitizenScriptInfo cs 
	inner join IEGExecutionState ie 
	on cs.scriptExecutionID = ie.executionID where cs.scripttype = 'OST06' and cs.status != 'CSS03' and ie.scriptCompleted = '1') csi 
on le.workingdata = csi.datastoreid;