APPS.JTY_TAE_CONTROL_PVT dependencies on DUAL

Line 312: FROM dual;

308:
309: /* Create Combinations in Product and Factor Tables */
310: SELECT JTF_TAE_ANALYZE_TERR_S.NEXTVAL
311: INTO l_terr_analyze_id
312: FROM dual;
313:
314: IF (p_qual_prd_tbl.COUNT > 0) THEN
315: FOR i IN p_qual_prd_tbl.FIRST .. p_qual_prd_tbl.LAST LOOP
316: l_counter := l_counter + 1;

Line 320: FROM dual;

316: l_counter := l_counter + 1;
317:
318: SELECT JTF_TAE_QUAL_PRODUCTS_S.NEXTVAL
319: INTO l_qual_product_id
320: FROM dual;
321:
322: -- POPULATE PRODUCTS
323: IF ((p_qual_prd_tbl(i) <> 1) AND (p_qual_prd_tbl(i) IS NOT NULL)) THEN
324:

Line 376: FROM dual;

372: IF (l_no_of_records = 0) THEN
373:
374: SELECT jty_terr_values_idx_header_s.nextval
375: INTO l_header_seq
376: FROM dual;
377:
378: SELECT 'JTY_DNM_ATTR_VAL_' || abs(l_qual_type_usg_id) || '_BN' ||
379: (nvl(max(to_number(substr(index_name, instr(index_name, '_BN')+3))), 0) + 1)
380: INTO l_index_name

Line 426: FROM dual;

422: BEGIN
423:
424: SELECT JTF_TAE_QUAL_factors_s.NEXTVAL
425: INTO l_qual_factor_id
426: FROM dual;
427:
428: INSERT INTO JTF_TAE_QUAL_factors
429: ( QUAL_FACTOR_ID,
430: RELATION_FACTOR,

Line 871: FROM dual;

867: AND rownum < 2;
868:
869: SELECT JTF_TAE_QUAL_PROD_FACTORS_S.NEXTVAL
870: INTO l_qual_prod_factor_id
871: FROM dual;
872:
873: INSERT INTO JTF_TAE_QUAL_prod_factors
874: ( QUAL_PROD_FACTOR_ID,
875: QUAL_PRODUCT_ID,

Line 1027: FROM dual;

1023:
1024: /* Create Combinations in Product and Factor Tables */
1025: SELECT JTF_TAE_ANALYZE_TERR_S.NEXTVAL
1026: INTO l_terr_analyze_id
1027: FROM dual;
1028:
1029: l_counter := 0;
1030:
1031: IF (p_qual_prd_tbl.COUNT > 0) THEN

Line 1037: FROM dual;

1033: l_counter := l_counter + 1;
1034:
1035: SELECT JTY_DEA_ATTR_PRODUCTS_S.NEXTVAL
1036: INTO l_qual_product_id
1037: FROM dual;
1038:
1039: -- POPULATE PRODUCTS
1040: IF ((p_qual_prd_tbl(i) <> 1) AND (p_qual_prd_tbl(i) IS NOT NULL)) THEN
1041:

Line 1093: FROM dual;

1089: IF (l_no_of_records = 0) THEN
1090:
1091: SELECT jty_dea_values_idx_header_s.nextval
1092: INTO l_header_seq
1093: FROM dual;
1094:
1095: INSERT INTO jty_dea_values_idx_header (
1096: dea_values_idx_header_id
1097: ,source_id

Line 1137: FROM dual;

1133: BEGIN
1134:
1135: SELECT JTY_DEA_ATTR_FACTORS_S.NEXTVAL
1136: INTO l_qual_factor_id
1137: FROM dual;
1138:
1139: INSERT INTO JTY_DEA_ATTR_FACTORS
1140: ( DEA_ATTR_FACTORS_ID,
1141: RELATION_FACTOR,

Line 1580: FROM dual;

1576: AND rownum < 2;
1577:
1578: SELECT JTY_DEA_ATTR_PROD_FACTORS_S.NEXTVAL
1579: INTO l_qual_prod_factor_id
1580: FROM dual;
1581:
1582: INSERT INTO JTY_DEA_ATTR_PROD_FACTORS
1583: ( DEA_ATTR_PROD_FACTORS_ID,
1584: DEA_ATTR_PRODUCTS_ID,