APPS.JTF_NAV_VIEWBYS_PKG dependencies on JTF_NAV_VIEWBYS_S
Line 18: SELECT jtf_nav_viewbys_s.nextval
14:
15: l_viewby_id number := 0;
16:
17: BEGIN 18: SELECT jtf_nav_viewbys_s.nextval 19: INTO l_viewby_id
20: FROM dual;
21: insert into JTF_NAV_VIEWBYS_B
22: (viewby_id,
Line 289: SELECT jtf_nav_viewbys_s.nextval
285: WHERE viewby_value = x_viewby_value;
286:
287: IF (SQL%NOTFOUND) THEN
288: -- Insert new record to _B table 289: SELECT jtf_nav_viewbys_s.nextval 290: INTO l_viewby_id
291: FROM dual;
292:
293: INSERT INTO jtf_nav_viewbys_b