select distinct mtv.motivationid
into 
	:motivationid
from motivation mtv
where username=:username
and not exists (
	select * 
	from intakeapplication
	where intakeapplication.rootentityid=mtv.datastoreid
) and not exists (
	select *
	from MotivationIntakeAppLink
	where MotivationIntakeAppLink.motiveid = mtv.motivationid )