APPS.JTF_TAE_CONTROL_PVT dependencies on DUAL

Line 456: FROM dual;

452:
453:
454: SELECT JTF_TAE_ANALYZE_TERR_S.NEXTVAL
455: INTO l_terr_analyze_id
456: FROM dual;
457: --dbms_output.put_line(' l_terr_analyze_id= ' || l_terr_analyze_id);
458:
459: BEGIN
460:

Line 502: FROM dual;

498: l_char_tx_id := ABS(l_trans_id);
499:
500: SELECT JTF_TAE_QUAL_PRODUCTS_S.NEXTVAL
501: INTO l_qual_product_id
502: FROM dual;
503:
504: --dbms_output.put_line(' CURSOR NUMBER ' || l_counter || ' total_terr_count: ' || rel_set.total_count || ' / qual_relation_product: ' || rel_set.qual_relation_product);
505: total_terr_all_orgs := total_terr_all_orgs + rel_set.total_count;
506:

Line 579: FROM dual;

575: BEGIN
576:
577: SELECT JTF_TAE_QUAL_factors_s.NEXTVAL
578: INTO l_qual_factor_id
579: FROM dual;
580:
581: INSERT INTO JTF_TAE_QUAL_factors
582: ( QUAL_FACTOR_ID ,
583: RELATION_FACTOR ,

Line 661: FROM dual;

657: AND rownum < 2;
658:
659: SELECT JTF_TAE_QUAL_PROD_FACTORS_S.NEXTVAL
660: INTO l_qual_prod_factor_id
661: FROM dual;
662:
663: INSERT INTO JTF_TAE_QUAL_prod_factors
664: ( QUAL_PROD_FACTOR_ID,
665: QUAL_PRODUCT_ID,