APPS.JTF_NAV_TREE_ROOTS_PKG dependencies on JTF_NAV_TREE_ROOTS_S
Line 18: SELECT jtf_nav_tree_roots_s.nextval
14:
15: l_tree_root_id number := 0;
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,
Line 288: SELECT jtf_nav_tree_roots_s.nextval
284: WHERE root_value = x_root_value;
285:
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