oracle8.1.6
select group_id from rule_history_actions where rha_id=:r_id
select user_id from rule_history_actions where rha_id=:r_id
select to_date (sysdate,'YYYY-MM-DD') from dual
update rule_history_actions set processing_date=:today, approved_p='y' where rha_id=:r_id