APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on JTY_WEBADI_OTH_TERR_INTF_S
Line 1661: SELECT jty_webadi_oth_terr_intf_s.nextval
1657: l_mode := nvl(p_mode, 'NODE');
1658: l_view := nvl(p_view, 'TERR');
1659:
1660: BEGIN 1661: SELECT jty_webadi_oth_terr_intf_s.nextval 1662: INTO l_seq
1663: FROM dual;
1664: -- remove existing old data which is older than 3 days
1665: --Following query changed for bug 8734322 to stop webadi territory tables to grow in size because earlier where condition