APPS.JTF_TTY_NA_GEO_TERR_PVT dependencies on JTF_TERR_RSC_S

Line 1323: SELECT JTF_TERR_RSC_S.nextval

1319: where terr_id = x_terr_id;
1320:
1321: l_init_msg_list :=FND_API.G_TRUE;
1322:
1323: SELECT JTF_TERR_RSC_S.nextval
1324: into l_terr_rsc_id
1325: FROM DUAL;
1326:
1327: l_TerrRsc_Tbl(1).terr_id := x_terr_id;

Line 1714: SELECT JTF_TERR_RSC_S.nextval

1710: FOR rsc in resource_grp(naterr.terr_group_account_id,tran_type.role_code)
1711: loop
1712: i:=i+1;
1713:
1714: SELECT JTF_TERR_RSC_S.nextval
1715: into l_terr_rsc_id
1716: FROM DUAL;
1717:
1718: l_TerrRsc_Tbl(i).terr_id := x_terr_id;

Line 2106: SELECT JTF_TERR_RSC_S.nextval

2102: FOR rsc in resource_grp(naterr.terr_group_account_id,tran_type.role_code)
2103: loop
2104: i:=i+1;
2105:
2106: SELECT JTF_TERR_RSC_S.nextval
2107: into l_terr_rsc_id
2108: FROM DUAL;
2109:
2110: l_TerrRsc_Tbl(i).terr_id := x_terr_id;

Line 2940: SELECT JTF_TERR_RSC_S.nextval

2936: for rsc in resource_grp(overlayterr.terr_group_account_id,pit.role_code) loop
2937:
2938: i:=i+1;
2939:
2940: SELECT JTF_TERR_RSC_S.nextval
2941: into l_terr_rsc_id
2942: FROM DUAL;
2943:
2944: l_TerrRsc_Tbl(i).terr_id := x_terr_id;

Line 3524: SELECT JTF_TERR_RSC_S.nextval

3520: , pit.role_code) loop
3521:
3522: i:=i+1;
3523:
3524: SELECT JTF_TERR_RSC_S.nextval
3525: into l_terr_rsc_id
3526: FROM DUAL;
3527:
3528: l_TerrRsc_Tbl(i).terr_id := x_terr_id;

Line 4314: SELECT JTF_TERR_RSC_S.nextval

4310: loop
4311:
4312: i := i+1;
4313:
4314: SELECT JTF_TERR_RSC_S.nextval
4315: into l_terr_rsc_id
4316: FROM DUAL;
4317:
4318: l_TerrRsc_Tbl(i).terr_id := x_terr_id;

Line 5107: SELECT JTF_TERR_RSC_S.nextval

5103: loop
5104:
5105: i:=i+1;
5106:
5107: SELECT JTF_TERR_RSC_S.nextval
5108: into l_terr_rsc_id
5109: FROM DUAL;
5110:
5111: l_TerrRsc_Tbl(i).terr_id := x_terr_id;