21: -- of each table get updated
22:
23: SELECT jtf_nav_tabs_s.nextval
24: INTO l_tab_id 25: FROM dual; 26: insert into JTF_NAV_TABS_b
27: (tab_id,
28: TAB_VALUE,
29: NAVIGATOR_TYPE,
Line 304: FROM dual;
300: IF (SQL%NOTFOUND) THEN
301: -- Insert new record to _B table
302: SELECT jtf_nav_tabs_s.nextval
303: INTO l_tab_id 304: FROM dual; 305:
306: INSERT INTO jtf_nav_tabs_b
307: (tab_id,
308: tab_value,