oracle8.1.6 select * from survey_questions where section_id in (select section_id from survey_sections ss where ss.survey_id=:survey_id) select * from rules where asm_id=:survey_id select result_id,rule_def_id, qs_id, active_p, rule_id from rules_triggers where rule_id=:rule_id select choice_id from survey_question_responses where question_id=:qs_id and response_id=:response_id select * from rules_actions where rule_id=:rule_id select group_name as pretty_name from groups where group_id=:group_id select to_date(sysdate,'YYYY-MM-DD') from dual select p.first_names || ' ' || p.last_name as name from persons p where p.person_id = :user_id select number_answer from survey_question_responses where question_id = :s_id and response_id = :response_id insert into rule_history_actions (rha_id,group_id,user_id,rule_action_id,request_date,processing_date,approved_p) values (:rha_id,:group_id,:user_id,:rule_action_id,to_date(:today,'YYYY-MM-DD'),to_date(:today,'YYYY-MM-DD'),'y') insert into rule_history_actions (rha_id,group_id,user_id,rule_action_id,request_date,processing_date,approved_p) values (:rha_id,:group_id,:user_id,:rule_action_id,to_date(:today,'YYYY-MM-DD'),'','n') insert into rule_history_actions (rha_id,group_id,user_id,rule_action_id,request_date,processing_date,approved_p) values (:rha_id,-1,:user_id,:rule_action_id,to_date(:today,'YYYY-MM-DD'),to_date(:today,'YYYY-MM-DD'),'y')