APPS.JTY_WEBADI_OTH_TERR_UPDATE_PKG dependencies on JTF_TERR_USGS_ALL

Line 1885: DELETE from JTF_TERR_USGS_ALL WHERE TERR_ID = l_del_terr_rec.terr_id(i);

1881: DELETE from JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID = l_del_terr_rec.terr_id(i);
1882:
1883: forall i in l_del_terr_rec.terr_id.first..l_del_terr_rec.terr_id.last
1884: --Delete Territory usgs
1885: DELETE from JTF_TERR_USGS_ALL WHERE TERR_ID = l_del_terr_rec.terr_id(i);
1886:
1887: forall i in l_del_terr_rec.terr_id.first..l_del_terr_rec.terr_id.last
1888: --Delete Territory Resource Access
1889: DELETE from JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN

Line 2450: INSERT INTO JTF_TERR_USGS_ALL(

2446: and USER_SEQUENCE = P_USER_SEQUENCE
2447: and interface_type = l_intf_type
2448: and action_flag = p_action_flag;
2449:
2450: INSERT INTO JTF_TERR_USGS_ALL(
2451: TERR_USG_ID,
2452: LAST_UPDATE_DATE,
2453: LAST_UPDATED_BY,
2454: CREATION_DATE,