APPS.CS_SR_PROB_CODE_MAPPING_PKG dependencies on MTL_CATEGORY_SET_VALID_CATS

Line 545: SELECT category_id from mtl_category_set_valid_cats

541: (end_date_active is null or trunc(end_date_active) >= trunc(sysdate));
542: c_sr_criteria_exists_rec c_sr_criteria_exists_csr%ROWTYPE;
543:
544: CURSOR c_sr_prod_cat_valid_csr IS
545: SELECT category_id from mtl_category_set_valid_cats
546: WHERE category_set_id = to_number(l_product_category_set)
547: AND category_id = l_product_category_id;
548:
549: CURSOR c_sr_problem_code_valid_csr IS