You've not said which version so I've assumed 9i in which the following will work.
WHERE (SELECT condition_column FROM condition_table) = condition_to_proceed
If you have a STATE table with a column TEST and you want to make sure TEST = 1 to proceed your statement would look like
WHERE (SELECT test FROM state) = 1;
Hope that helps
Oracle Certified Professional "Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"