2092:
2093:
2094: CURSOR c_get_qualrel_prod(cl_source_id number, cl_trans_id number) IS
2095: SELECT jtqp.relation_product
2096: FROM jtf_tae_qual_products jtqp
2097: WHERE jtqp.source_id = cl_source_id
2098: AND jtqp.trans_object_type_id = cl_trans_id
2099: ORDER BY jtqp.relation_product DESC;
2100:
3703: l_sysdate DATE;
3704:
3705: CURSOR c_get_qualrel_prod(cl_source_id number, cl_trans_id number) IS
3706: SELECT jtqp.relation_product
3707: FROM jtf_tae_qual_products jtqp
3708: WHERE jtqp.source_id = cl_source_id
3709: AND jtqp.trans_object_type_id = cl_trans_id
3710: ORDER BY jtqp.relation_product DESC;
3711: