APPS.JTY_ASSIGN_BULK_PUB dependencies on JTY_DEA_ATTR_PRODUCTS

Line 3910: FROM jty_dea_attr_products jtqp

3906: ORDER BY jtqp.relation_product DESC;
3907:
3908: CURSOR c_dea_get_qualrel_prod(cl_source_id number, cl_trans_id number) IS
3909: SELECT jtqp.attr_relation_product
3910: FROM jty_dea_attr_products jtqp
3911: WHERE jtqp.source_id = cl_source_id
3912: AND jtqp.trans_type_id = cl_trans_id
3913: ORDER BY jtqp.attr_relation_product DESC;
3914:

Line 3963: FROM jty_dea_attr_products_sql

3959: FOR jtf_csr IN c_dea_get_qualrel_prod(p_source_id, p_trans_id) LOOP
3960: BEGIN
3961: SELECT batch_dea_match_sql
3962: INTO l_match_sql
3963: FROM jty_dea_attr_products_sql
3964: WHERE source_id = p_source_id
3965: AND trans_type_id = p_trans_id
3966: AND program_name = p_program_name
3967: AND attr_relation_product = jtf_csr.attr_relation_product;