APPS.JTF_TTY_GEN_TERR_PVT dependencies on JTF_TERR_USGS_ALL

Line 274: DELETE FROM JTF_TERR_USGS_ALL jtu

270: WHERE jt.terr_group_flag = 'Y' );
271:
272:
273: --Delete Territory usgs
274: DELETE FROM JTF_TERR_USGS_ALL jtu
275: WHERE jtu.terr_id IN
276: ( SELECT jt.terr_id
277: FROM jtf_terr_all jt
278: WHERE jt.terr_group_flag = 'Y' );

Line 350: DELETE FROM JTF_TERR_USGS_ALL WHERE TERR_ID IN

346: DELETE FROM JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID IN
347: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE GEO_TERRITORY_ID = p_geo_territory_id );
348:
349: --Delete Territory usgs
350: DELETE FROM JTF_TERR_USGS_ALL WHERE TERR_ID IN
351: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE GEO_TERRITORY_ID = p_geo_territory_id );
352:
353: --Delete Territory Resource Access
354: DELETE FROM JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN

Line 413: DELETE FROM JTF_TERR_USGS_ALL WHERE TERR_ID IN

409: DELETE FROM JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID IN
410: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE TERR_GROUP_ACCOUNT_ID = p_terr_grp_acct_id );
411:
412: --Delete Territory usgs
413: DELETE FROM JTF_TERR_USGS_ALL WHERE TERR_ID IN
414: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE TERR_GROUP_ACCOUNT_ID = p_terr_grp_acct_id );
415:
416: --Delete Territory Resource Access
417: DELETE FROM JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN

Line 515: DELETE from JTF_TERR_USGS_ALL WHERE TERR_ID IN

511: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE TERR_GROUP_ACCOUNT_ID = p_grpAcctId_tbl(idx) );
512:
513: --Delete Territory usgs
514: forall idx in p_grpAcctId_tbl.FIRST .. p_grpAcctId_tbl.LAST
515: DELETE from JTF_TERR_USGS_ALL WHERE TERR_ID IN
516: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE TERR_GROUP_ACCOUNT_ID = p_grpAcctId_tbl(idx) );
517:
518: --Delete Territory Resource Access
519: forall idx in p_grpAcctId_tbl.FIRST .. p_grpAcctId_tbl.LAST

Line 718: DELETE FROM JTF_TERR_USGS_ALL WHERE TERR_ID IN

714: DELETE FROM JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID IN
715: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE TERR_GROUP_ID = p_terr_grp_id );
716:
717: --Delete Territory usgs
718: DELETE FROM JTF_TERR_USGS_ALL WHERE TERR_ID IN
719: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE TERR_GROUP_ID = p_terr_grp_id );
720:
721: --Delete Territory Resource Access
722: DELETE FROM JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN

Line 761: DELETE FROM JTF_TERR_USGS_ALL WHERE TERR_ID IN

757: WHERE TERR_GROUP_ID = p_terr_grp_id
758: );
759:
760: --Delete Territory usgs
761: DELETE FROM JTF_TERR_USGS_ALL WHERE TERR_ID IN
762: ( SELECT TERR_ID FROM JTF_TERR_ALL
763: WHERE TERR_GROUP_ID = p_terr_grp_id
764: -- AND TERR_ID <> p_terr_id
765: );