APPS.JTF_TERR_ENGINE_GEN_PVT dependencies on JTF_TERR_USGS_S

Line 963: SELECT JTF_TERR_USGS_S.nextval

959: l_terr_all_rec.ORG_ID := terr_group.ORG_ID;
960:
961:
962: /* ORACLE SALES AND TELESALES USAGE */
963: SELECT JTF_TERR_USGS_S.nextval
964: INTO l_terr_usg_id
965: FROM DUAL;
966:
967: l_terr_usgs_tbl(1).SOURCE_ID := -1001;

Line 1135: SELECT JTF_TERR_USGS_S.nextval

1131: l_terr_all_rec.NUM_WINNERS := null ;
1132:
1133:
1134: /* Oracle Sales and Telesales Usage */
1135: SELECT JTF_TERR_USGS_S.nextval
1136: into l_terr_usg_id
1137: FROM DUAL;
1138:
1139: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;

Line 1505: SELECT JTF_TERR_USGS_S.nextval

1501: l_terr_all_rec.NUM_WINNERS :=null ;
1502:
1503:
1504: /* Oracle Sales and Telesales Usage */
1505: SELECT JTF_TERR_USGS_S.nextval
1506: into l_terr_usg_id
1507: FROM DUAL;
1508:
1509: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;

Line 1899: SELECT JTF_TERR_USGS_S.nextval

1895: l_terr_all_rec.NUM_WINNERS :=null ;
1896:
1897:
1898: /* Oracle Sales and Telesales Usage */
1899: SELECT JTF_TERR_USGS_S.nextval
1900: into l_terr_usg_id
1901: FROM DUAL;
1902:
1903: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;

Line 2322: SELECT JTF_TERR_USGS_S.nextval

2318: l_terr_all_rec.ORG_ID :=terr_group.ORG_ID ;
2319: l_terr_all_rec.NUM_WINNERS :=l_pi_count ;
2320:
2321: /* ORACLE SALES AND TELESALES USAGE */
2322: SELECT JTF_TERR_USGS_S.nextval
2323: into l_terr_usg_id
2324: FROM DUAL;
2325:
2326: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;

Line 2525: SELECT JTF_TERR_USGS_S.nextval

2521: l_terr_all_rec.ORG_ID :=terr_group.ORG_ID ;
2522: l_terr_all_rec.NUM_WINNERS :=null ;
2523:
2524:
2525: SELECT JTF_TERR_USGS_S.nextval
2526: into l_terr_usg_id
2527: FROM DUAL;
2528:
2529: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;

Line 2716: SELECT JTF_TERR_USGS_S.nextval

2712:
2713: l_terr_all_rec.ORG_ID :=terr_group.ORG_ID ;
2714: l_terr_all_rec.NUM_WINNERS :=null ;
2715:
2716: SELECT JTF_TERR_USGS_S.nextval
2717: into l_terr_usg_id
2718: FROM DUAL;
2719:
2720: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;

Line 3108: SELECT JTF_TERR_USGS_S.nextval

3104: l_terr_all_rec.ORG_ID :=terr_group.ORG_ID ;
3105: l_terr_all_rec.NUM_WINNERS :=null ;
3106:
3107:
3108: SELECT JTF_TERR_USGS_S.nextval
3109: into l_terr_usg_id
3110: FROM DUAL;
3111:
3112: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;

Line 3295: SELECT JTF_TERR_USGS_S.nextval

3291:
3292: l_terr_all_rec.ORG_ID :=terr_group.ORG_ID ;
3293: l_terr_all_rec.NUM_WINNERS :=null ;
3294:
3295: SELECT JTF_TERR_USGS_S.nextval
3296: into l_terr_usg_id
3297: FROM DUAL;
3298:
3299: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;