16:
17: BEGIN
18: SELECT jtf_nav_tree_roots_s.nextval
19: INTO l_tree_root_id 20: FROM dual; 21: insert into JTF_NAV_TREE_ROOTS_B (
22: tree_root_id,
23: ROOT_VALUE,
24: VIEWBY_id,
Line 290: FROM dual;
286: IF (SQL%NOTFOUND) THEN
287: -- Insert new record to _B table
288: SELECT jtf_nav_tree_roots_s.nextval
289: INTO l_tree_root_id 290: FROM dual; 291:
292: INSERT INTO jtf_nav_tree_roots_b
293: (tree_root_id,
294: root_value,