APPS.JTF_TTY_GEN_TERR_PVT dependencies on JTF_TERR_QTYPE_USGS_ALL

Line 266: DELETE FROM JTF_TERR_QTYPE_USGS_ALL jtqu

262: WHERE jt.terr_group_flag = 'Y' );
263:
264:
265: --Delete Territory qual type usgs
266: DELETE FROM JTF_TERR_QTYPE_USGS_ALL jtqu
267: WHERE jtqu.terr_id IN
268: ( SELECT jt.terr_id
269: FROM jtf_terr_all jt
270: WHERE jt.terr_group_flag = 'Y' );

Line 346: DELETE FROM JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID IN

342: DELETE FROM JTF_TERR_QUAL_ALL WHERE TERR_ID IN
343: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE GEO_TERRITORY_ID = p_geo_territory_id );
344:
345: --Delete Territory qual type usgs
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

Line 409: DELETE FROM JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID IN

405: DELETE FROM JTF_TERR_QUAL_ALL WHERE TERR_ID IN
406: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE TERR_GROUP_ACCOUNT_ID = p_terr_grp_acct_id );
407:
408: --Delete Territory qual type usgs
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

Line 510: DELETE from JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID IN

506: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE TERR_GROUP_ACCOUNT_ID = p_grpAcctId_tbl(idx) );
507:
508: --Delete Territory qual type usgs
509: forall idx in p_grpAcctId_tbl.FIRST .. p_grpAcctId_tbl.LAST
510: DELETE from JTF_TERR_QTYPE_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

Line 714: DELETE FROM JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID IN

710: DELETE FROM JTF_TERR_QUAL_ALL WHERE TERR_ID IN
711: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE TERR_GROUP_ID = p_terr_grp_id );
712:
713: --Delete Territory qual type usgs
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

Line 755: DELETE FROM JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID IN

751: AND TERR_ID <> p_terr_id
752: );
753:
754: --Delete Territory qual type usgs
755: DELETE FROM JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID IN
756: ( SELECT TERR_ID FROM JTF_TERR_ALL
757: WHERE TERR_GROUP_ID = p_terr_grp_id
758: );
759: