Thanks; the code helps alot. I will summarize and simplify:
Procedure has single input - essentially the name of the source table.
You then select rows from that source table and insert them into another table, the name of which is determined by the data in the source table rows.
So to verify that this program works, you need to create three outcomes for Queries, one for each of the three tables that could have received new rows.
Each outcome is defined as follows:
A. Changed by program: either the name of the table from one of the INTO clauses of the INSERT FIRST statement, or a query against that table using a WHERE clause to retrieve just the subset of rows that may have been inserted.
B. Test type is equality (=).
C. Expected results: should be set to a Query. Then in the text of the query put in the select statement that correctly identifies the rows from the original table that would have been copied over as in:
SELECT end_date, transaction_id, etc.
WHERE end_date is NULL
Again, you will need to create one of these outcomes for each of the tables that has received rows.
I hope this helps clarify what you should do.