APPS.JTY_TAE_CONTROL_PVT dependencies on JTY_DEA_ATTR_PRODUCTS_S

Line 101: DELETE FROM jty_dea_attr_products_sql

97: ( SELECT NULL
98: FROM jty_dea_attr_products i
99: WHERE MOD(i.attr_relation_product, o.relation_factor) = 0 );
100:
101: DELETE FROM jty_dea_attr_products_sql
102: WHERE source_id = p_source_id
103: AND trans_type_id = p_trans_id
104: AND keep_flag <> 'Y';
105:

Line 1007: SELECT JTY_DEA_ATTR_PRODUCTS_S.NEXTVAL

1003: IF (p_qual_prd_tbl.COUNT > 0) THEN
1004: FOR i IN p_qual_prd_tbl.FIRST .. p_qual_prd_tbl.LAST LOOP
1005: l_counter := l_counter + 1;
1006:
1007: SELECT JTY_DEA_ATTR_PRODUCTS_S.NEXTVAL
1008: INTO l_qual_product_id
1009: FROM dual;
1010:
1011: -- POPULATE PRODUCTS