APPS.JTY_TAE_CONTROL_PVT dependencies on DUAL

Line 271: FROM dual;

267:
268: /* Create Combinations in Product and Factor Tables */
269: SELECT JTF_TAE_ANALYZE_TERR_S.NEXTVAL
270: INTO l_terr_analyze_id
271: FROM dual;
272:
273: IF (p_qual_prd_tbl.COUNT > 0) THEN
274: FOR i IN p_qual_prd_tbl.FIRST .. p_qual_prd_tbl.LAST LOOP
275: l_counter := l_counter + 1;

Line 279: FROM dual;

275: l_counter := l_counter + 1;
276:
277: SELECT JTF_TAE_QUAL_PRODUCTS_S.NEXTVAL
278: INTO l_qual_product_id
279: FROM dual;
280:
281: -- POPULATE PRODUCTS
282: IF ((p_qual_prd_tbl(i) <> 1) AND (p_qual_prd_tbl(i) IS NOT NULL)) THEN
283:

Line 335: FROM dual;

331: IF (l_no_of_records = 0) THEN
332:
333: SELECT jty_terr_values_idx_header_s.nextval
334: INTO l_header_seq
335: FROM dual;
336:
337: SELECT 'JTY_DNM_ATTR_VAL_' || abs(l_qual_type_usg_id) || '_BN' ||
338: (nvl(max(to_number(substr(index_name, instr(index_name, '_BN')+3))), 0) + 1)
339: INTO l_index_name

Line 385: FROM dual;

381: BEGIN
382:
383: SELECT JTF_TAE_QUAL_factors_s.NEXTVAL
384: INTO l_qual_factor_id
385: FROM dual;
386:
387: INSERT INTO JTF_TAE_QUAL_factors
388: ( QUAL_FACTOR_ID,
389: RELATION_FACTOR,

Line 830: FROM dual;

826: AND rownum < 2;
827:
828: SELECT JTF_TAE_QUAL_PROD_FACTORS_S.NEXTVAL
829: INTO l_qual_prod_factor_id
830: FROM dual;
831:
832: INSERT INTO JTF_TAE_QUAL_prod_factors
833: ( QUAL_PROD_FACTOR_ID,
834: QUAL_PRODUCT_ID,

Line 999: FROM dual;

995:
996: /* Create Combinations in Product and Factor Tables */
997: SELECT JTF_TAE_ANALYZE_TERR_S.NEXTVAL
998: INTO l_terr_analyze_id
999: FROM dual;
1000:
1001: l_counter := 0;
1002:
1003: IF (p_qual_prd_tbl.COUNT > 0) THEN

Line 1009: FROM dual;

1005: l_counter := l_counter + 1;
1006:
1007: SELECT JTY_DEA_ATTR_PRODUCTS_S.NEXTVAL
1008: INTO l_qual_product_id
1009: FROM dual;
1010:
1011: -- POPULATE PRODUCTS
1012: IF ((p_qual_prd_tbl(i) <> 1) AND (p_qual_prd_tbl(i) IS NOT NULL)) THEN
1013:

Line 1065: FROM dual;

1061: IF (l_no_of_records = 0) THEN
1062:
1063: SELECT jty_dea_values_idx_header_s.nextval
1064: INTO l_header_seq
1065: FROM dual;
1066:
1067: INSERT INTO jty_dea_values_idx_header (
1068: dea_values_idx_header_id
1069: ,source_id

Line 1107: FROM dual;

1103: BEGIN
1104:
1105: SELECT JTY_DEA_ATTR_FACTORS_S.NEXTVAL
1106: INTO l_qual_factor_id
1107: FROM dual;
1108:
1109: INSERT INTO JTY_DEA_ATTR_FACTORS
1110: ( DEA_ATTR_FACTORS_ID,
1111: RELATION_FACTOR,

Line 1550: FROM dual;

1546: AND rownum < 2;
1547:
1548: SELECT JTY_DEA_ATTR_PROD_FACTORS_S.NEXTVAL
1549: INTO l_qual_prod_factor_id
1550: FROM dual;
1551:
1552: INSERT INTO JTY_DEA_ATTR_PROD_FACTORS
1553: ( DEA_ATTR_PROD_FACTORS_ID,
1554: DEA_ATTR_PRODUCTS_ID,