APPS.JTY_TAE_CONTROL_PVT dependencies on JTY_DEA_ATTR_PRODUCTS_SQL

Line 111: DELETE FROM jty_dea_attr_products_sql

107: ( SELECT NULL
108: FROM jty_dea_attr_products i
109: WHERE MOD(i.attr_relation_product, o.relation_factor) = 0 );
110:
111: DELETE FROM jty_dea_attr_products_sql
112: WHERE source_id = p_source_id
113: AND trans_type_id = p_trans_id
114: AND keep_flag <> 'Y';
115:

Line 192: DELETE FROM jty_dea_attr_products_sql

188: WHERE MOD(i.attr_relation_product, o.relation_factor) = 0 );
189:
190: IF (l_rel_prd_tbl.COUNT > 0) THEN
191: FORALL i IN l_rel_prd_tbl.FIRST .. l_rel_prd_tbl.LAST
192: DELETE FROM jty_dea_attr_products_sql
193: WHERE source_id = p_source_id
194: AND trans_type_id = p_trans_id
195: AND attr_relation_product = l_rel_prd_tbl(i)
196: AND keep_flag <> 'Y';