I have a datawarehouse report that sends to the internal users a list of cases for each month and they are divided based on severity. Severity A cases will have to respond within a day and severity B cases has to be responded by 2-3 days. I want to convert this as table based rules so that if and when a B case happen to be A it is easily configurable. My design for this to implement a table that has type A or B and then rules having id 1,2 and then third column will be the actual sql statement. Then I will have a package that will read this table and execute the sql statement (execute immediate) to produce results.
Is there any other better way to design the above requirement?