APPS.JTY_TAE_CONTROL_PVT dependencies on JTY_TAE_ATTR_PRODUCTS_SQL

Line 81: DELETE FROM jty_tae_attr_products_sql

77: ( SELECT NULL
78: FROM jtf_tae_qual_products i
79: WHERE MOD(i.relation_product, o.relation_factor) = 0 );
80:
81: DELETE FROM jty_tae_attr_products_sql
82: WHERE source_id = p_source_id
83: AND trans_type_id = p_trans_id
84: AND keep_flag <> 'Y';
85:

Line 151: DELETE FROM jty_tae_attr_products_sql

147: WHERE MOD(i.relation_product, o.relation_factor) = 0 );
148:
149: IF (l_rel_prd_tbl.COUNT > 0) THEN
150: FORALL i IN l_rel_prd_tbl.FIRST .. l_rel_prd_tbl.LAST
151: DELETE FROM jty_tae_attr_products_sql
152: WHERE source_id = p_source_id
153: AND trans_type_id = p_trans_id
154: AND attr_relation_product = l_rel_prd_tbl(i)
155: AND keep_flag <> 'Y';