APPS.FTE_UTIL_PKG dependencies on MTL_CATEGORIES_KFV

Line 500: FROM mtl_categories_kfv c, mtl_category_sets s

496:
497: BEGIN
498: SELECT category_id
499: INTO l_id
500: FROM mtl_categories_kfv c, mtl_category_sets s
501: WHERE s.structure_id = c.structure_id
502: AND s.category_set_name = 'WSH_COMMODITY_CODE'
503: AND c.concatenated_segments like l_value||'%'
504: AND rownum = 1;

Line 544: FROM mtl_categories_kfv c, mtl_category_sets s

540: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.GET_CATEGORY_ID';
541:
542: CURSOR get_freight_classes IS
543: SELECT c.category_id, c.concatenated_segments, c.segment1, c.segment2, c.segment3
544: FROM mtl_categories_kfv c, mtl_category_sets s
545: WHERE s.structure_id = c.structure_id
546: AND s.category_set_name = 'WSH_COMMODITY_CODE';
547:
548: CURSOR get_delimiter IS