APPS.JTF_NAV_TABS_PKG dependencies on JTF_NAV_TABS_S

Line 23: SELECT jtf_nav_tabs_s.nextval

19: BEGIN
20: -- since our view is based on two tables, make sure the right columns
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,

Line 302: SELECT jtf_nav_tabs_s.nextval

298: WHERE tab_value = x_tab_value;
299:
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