116: -- --------------------------------------------------------------
117: -- Check the database for the "before" image. We need to compare
118: -- the before image to the after image.
119: -- --------------------------------------------------------------
120: FOR x IN (SELECT status_code FROM pv_process_rules_b
121: WHERE process_rule_id = p_SELCRIT_rec.PROCESS_RULE_ID)
122: LOOP
123: l_previous_status := x.status_code;
124: END LOOP;
379: -- --------------------------------------------------------------
380: -- Check the database for the "before" image. We need to compare
381: -- the before image to the after image.
382: -- --------------------------------------------------------------
383: FOR x IN (SELECT status_code FROM pv_process_rules_b
384: WHERE process_rule_id = p_SELCRIT_rec.PROCESS_RULE_ID)
385: LOOP
386: l_previous_status := x.status_code;
387: END LOOP;