APPS.EGO_ITEM_PUB dependencies on MTL_CATEGORIES_KFV

Line 4015: FROM MTL_CATEGORIES_KFV C

4011: FETCH get_parent_category_id_csr into l_parent_categories;
4012: EXIT WHEN get_parent_category_id_csr%NOTFOUND;
4013:
4014: SELECT C.CONCATENATED_SEGMENTS into l_category_name
4015: FROM MTL_CATEGORIES_KFV C
4016: WHERE C.CATEGORY_ID = l_parent_categories.CATEGORY_ID;
4017:
4018: l_tmp_names := l_category_hierarchy_names;
4019: IF (l_tmp_names IS NULL) THEN

Line 4033: FROM MTL_CATEGORIES_KFV C

4029: IF l_tmp_names IS NOT NULL THEN
4030: l_category_hierarchy_names := l_category_set_name || ' > ' || l_tmp_names;
4031: ELSE
4032: SELECT C.CONCATENATED_SEGMENTS into l_category_hierarchy_names
4033: FROM MTL_CATEGORIES_KFV C
4034: WHERE C.CATEGORY_ID = p_category_id;
4035: END IF;
4036:
4037: RETURN l_category_hierarchy_names;