DBA Data[Home] [Help]

APPS.JTY_TERR_ENGINE_GEN_PVT dependencies on JTF_TAE_QUAL_PRODUCTS

Line 426: /* delete the old records from the tables jtf_tae_qual_products, jtf_tae_qual_factors */

422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
424:
425:
426: /* delete the old records from the tables jtf_tae_qual_products, jtf_tae_qual_factors */
427: /* and jtf_tae_qual_prod_factors if mode is total or incremental */
428: /* delete the old records from the tables jtf_dea_attr_products, jtf_dea_attr_factors */
429: /* and jtf_dea_attr_prod_factors if mode is date effective */
430: JTY_TAE_CONTROL_PVT.delete_combinations(

Line 484: FROM jtf_tae_qual_products c

480: AND c.end_date_active > sysdate
481: AND a.qual_relation_product <> 1
482: AND NOT EXISTS (
483: SELECT 1
484: FROM jtf_tae_qual_products c
485: WHERE c.source_id = p_source_id
486: AND c.trans_object_type_id = l_qual_type_id_tbl(i)
487: AND c.relation_product = a.qual_relation_product);
488: