APPS.JTF_TTY_NA_GEO_TERR_PVT dependencies on JTF_TERR_USGS_S

Line 975: SELECT JTF_TERR_USGS_S.nextval

971: l_terr_all_rec.ORG_ID := terr_group.ORG_ID;
972:
973:
974: /* ORACLE SALES AND TELESALES USAGE */
975: SELECT JTF_TERR_USGS_S.nextval
976: INTO l_terr_usg_id
977: FROM DUAL;
978:
979: l_terr_usgs_tbl(1).SOURCE_ID := -1001;

Line 1149: SELECT JTF_TERR_USGS_S.nextval

1145: l_terr_all_rec.NUM_WINNERS := null ;
1146:
1147:
1148: /* Oracle Sales and Telesales Usage */
1149: SELECT JTF_TERR_USGS_S.nextval
1150: into l_terr_usg_id
1151: FROM DUAL;
1152:
1153: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;

Line 1519: SELECT JTF_TERR_USGS_S.nextval

1515: l_terr_all_rec.NUM_WINNERS :=null ;
1516:
1517:
1518: /* Oracle Sales and Telesales Usage */
1519: SELECT JTF_TERR_USGS_S.nextval
1520: into l_terr_usg_id
1521: FROM DUAL;
1522:
1523: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;

Line 1911: SELECT JTF_TERR_USGS_S.nextval

1907: l_terr_all_rec.NUM_WINNERS :=null ;
1908:
1909:
1910: /* Oracle Sales and Telesales Usage */
1911: SELECT JTF_TERR_USGS_S.nextval
1912: into l_terr_usg_id
1913: FROM DUAL;
1914:
1915: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;

Line 2333: SELECT JTF_TERR_USGS_S.nextval

2329: l_terr_all_rec.ORG_ID :=terr_group.ORG_ID ;
2330: l_terr_all_rec.NUM_WINNERS :=l_pi_count ;
2331:
2332: /* ORACLE SALES AND TELESALES USAGE */
2333: SELECT JTF_TERR_USGS_S.nextval
2334: into l_terr_usg_id
2335: FROM DUAL;
2336:
2337: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;

Line 2535: SELECT JTF_TERR_USGS_S.nextval

2531: l_terr_all_rec.ORG_ID :=terr_group.ORG_ID ;
2532: l_terr_all_rec.NUM_WINNERS :=null ;
2533:
2534:
2535: SELECT JTF_TERR_USGS_S.nextval
2536: into l_terr_usg_id
2537: FROM DUAL;
2538:
2539: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;

Line 2724: SELECT JTF_TERR_USGS_S.nextval

2720:
2721: l_terr_all_rec.ORG_ID :=terr_group.ORG_ID ;
2722: l_terr_all_rec.NUM_WINNERS :=null ;
2723:
2724: SELECT JTF_TERR_USGS_S.nextval
2725: into l_terr_usg_id
2726: FROM DUAL;
2727:
2728: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;

Line 3116: SELECT JTF_TERR_USGS_S.nextval

3112: l_terr_all_rec.ORG_ID :=terr_group.ORG_ID ;
3113: l_terr_all_rec.NUM_WINNERS :=null ;
3114:
3115:
3116: SELECT JTF_TERR_USGS_S.nextval
3117: into l_terr_usg_id
3118: FROM DUAL;
3119:
3120: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;

Line 3303: SELECT JTF_TERR_USGS_S.nextval

3299:
3300: l_terr_all_rec.ORG_ID :=terr_group.ORG_ID ;
3301: l_terr_all_rec.NUM_WINNERS :=null ;
3302:
3303: SELECT JTF_TERR_USGS_S.nextval
3304: into l_terr_usg_id
3305: FROM DUAL;
3306:
3307: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;

Line 4117: SELECT JTF_TERR_USGS_S.nextval

4113: l_terr_all_rec.NUM_WINNERS := null ;
4114:
4115: /* Oracle Sales and Telesales Usage */
4116:
4117: SELECT JTF_TERR_USGS_S.nextval
4118: into l_terr_usg_id
4119: FROM DUAL;
4120:
4121: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;

Line 4510: SELECT JTF_TERR_USGS_S.nextval

4506: l_terr_all_rec.NUM_WINNERS :=l_pi_count ;
4507:
4508: /* ORACLE SALES AND TELESALES USAGE */
4509:
4510: SELECT JTF_TERR_USGS_S.nextval
4511: into l_terr_usg_id
4512: FROM DUAL;
4513:
4514: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;

Line 4718: SELECT JTF_TERR_USGS_S.nextval

4714: l_terr_all_rec.ORG_ID :=p_ORG_ID ;
4715: l_terr_all_rec.NUM_WINNERS :=null ;
4716:
4717:
4718: SELECT JTF_TERR_USGS_S.nextval
4719: into l_terr_usg_id
4720: FROM DUAL;
4721:
4722: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;

Line 4899: SELECT JTF_TERR_USGS_S.nextval

4895:
4896: l_terr_all_rec.ORG_ID :=p_ORG_ID ;
4897: l_terr_all_rec.NUM_WINNERS :=null ;
4898:
4899: SELECT JTF_TERR_USGS_S.nextval
4900: into l_terr_usg_id
4901: FROM DUAL;
4902:
4903: l_terr_usgs_tbl(1).TERR_USG_ID := l_terr_usg_id;