APPS.JTF_TTY_GEN_TERR_PVT dependencies on JTF_TERR_RSC_ACCESS_ALL

Line 282: DELETE FROM JTF_TERR_RSC_ACCESS_ALL jtra

278: WHERE jt.terr_group_flag = 'Y' );
279:
280:
281: --Delete Territory Resource Access
282: DELETE FROM JTF_TERR_RSC_ACCESS_ALL jtra
283: WHERE jtra.terr_rsc_id IN
284: ( SELECT jtr.terr_rsc_id
285: FROM jtf_terr_rsc_all jtr, jtf_terr_all jt
286: WHERE jtr.terr_id = jt.terr_id

Line 354: DELETE FROM JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN

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
355: ( SELECT TERR_RSC_ID
356: FROM JTF_TERR_RSC_ALL A
357: ,JTF_TERR_ALL B
358: WHERE B.GEO_TERRITORY_ID = p_geo_territory_id

Line 417: DELETE FROM JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN

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
418: ( SELECT TERR_RSC_ID
419: FROM JTF_TERR_RSC_ALL A
420: ,JTF_TERR_ALL B
421: WHERE B.TERR_GROUP_ACCOUNT_ID = p_terr_grp_acct_id

Line 520: DELETE from JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_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
520: DELETE from JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN
521: ( SELECT TERR_RSC_ID
522: FROM JTF_TERR_RSC_ALL A
523: ,JTF_TERR_ALL B
524: WHERE B.TERR_GROUP_ACCOUNT_ID = p_grpAcctId_tbl(idx)

Line 722: DELETE FROM JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN

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
723: ( SELECT TERR_RSC_ID
724: FROM JTF_TERR_RSC_ALL A
725: ,JTF_TERR_ALL B
726: WHERE B.TERR_GROUP_ID = p_terr_grp_id

Line 768: DELETE FROM JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN

764: -- AND TERR_ID <> p_terr_id
765: );
766:
767: --Delete Territory Resource Access
768: DELETE FROM JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN
769: ( SELECT TERR_RSC_ID
770: FROM JTF_TERR_RSC_ALL A
771: ,JTF_TERR_ALL B
772: WHERE B.TERR_GROUP_ID = p_terr_grp_id

Line 12599: DELETE FROM JTF_TERR_RSC_ACCESS_ALL A

12595: CLOSE c_get_terr_id;
12596:
12597: IF ( l_catchall_terr_id <> -999 ) THEN
12598: BEGIN
12599: DELETE FROM JTF_TERR_RSC_ACCESS_ALL A
12600: WHERE A.TERR_RSC_ID IN ( SELECT B.TERR_RSC_ID
12601: FROM JTF_TERR_RSC_ALL B
12602: WHERE B.terr_id = l_catchall_terr_id );
12603:

Line 12642: DELETE FROM JTF_TERR_RSC_ACCESS_ALL A

12638:
12639: IF ( l_catchall_terr_id <> -999 ) THEN
12640: BEGIN
12641:
12642: DELETE FROM JTF_TERR_RSC_ACCESS_ALL A
12643: WHERE A.TERR_RSC_ID IN ( SELECT B.TERR_RSC_ID
12644: FROM JTF_TERR_RSC_ALL B
12645: WHERE B.terr_id = l_catchall_terr_id );
12646:

Line 12750: INSERT INTO jtf_terr_rsc_access_all

12746: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
12747: INTO l_terr_rsc_access_id
12748: FROM DUAL;
12749:
12750: INSERT INTO jtf_terr_rsc_access_all
12751: ( TERR_RSC_ACCESS_ID,
12752: LAST_UPDATE_DATE,
12753: LAST_UPDATED_BY,
12754: CREATION_DATE,

Line 12932: DELETE FROM JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN

12928:
12929: BEGIN
12930:
12931: --Delete Territory Resource Access
12932: DELETE FROM JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN
12933: ( SELECT TERR_RSC_ID
12934: FROM JTF_TERR_RSC_ALL A
12935: ,JTF_TERR_ALL B
12936: WHERE B.TERR_GROUP_ACCOUNT_ID = p_terr_grp_acct_id