DBA Data[Home] [Help]

APPS.JTY_TERR_ENGINE_GEN_PVT dependencies on JTF_TAE_QUAL_PRODUCTS

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

620: RAISE FND_API.G_EXC_ERROR;
621: END IF;
622:
623:
624: /* delete the old records from the tables jtf_tae_qual_products, jtf_tae_qual_factors */
625: /* and jtf_tae_qual_prod_factors if mode is total or incremental */
626: /* delete the old records from the tables jtf_dea_attr_products, jtf_dea_attr_factors */
627: /* and jtf_dea_attr_prod_factors if mode is date effective */
628: JTY_TAE_CONTROL_PVT.delete_combinations(

Line 680: FROM jtf_tae_qual_products c

676: AND c.end_date_active > sysdate
677: AND a.qual_relation_product <> 1
678: AND NOT EXISTS (
679: SELECT 1
680: FROM jtf_tae_qual_products c
681: WHERE c.source_id = p_source_id
682: AND c.trans_object_type_id = l_qual_type_id_tbl(i)
683: AND c.relation_product = a.qual_relation_product);
684: