APPS.CSP_EXCESS_PARTS_PVT dependencies on MTL_CATEGORY_SETS

Line 357: FROM MTL_CATEGORY_SETS

353: /* Validate cat set and MCAT struct */
354: IF (p_cat_set_id is not null and p_catg_struct_id is not null) then
355: SELECT STRUCTURE_ID
356: into l_mcat_struct_id
357: FROM MTL_CATEGORY_SETS
358: WHERE CATEGORY_SET_ID = p_cat_set_id;
359: ELSE
360: SELECT CSET.CATEGORY_SET_ID, CSET.STRUCTURE_ID
361: INTO l_category_set_id, l_mcat_struct_id

Line 362: FROM MTL_CATEGORY_SETS CSET,

358: WHERE CATEGORY_SET_ID = p_cat_set_id;
359: ELSE
360: SELECT CSET.CATEGORY_SET_ID, CSET.STRUCTURE_ID
361: INTO l_category_set_id, l_mcat_struct_id
362: FROM MTL_CATEGORY_SETS CSET,
363: MTL_DEFAULT_CATEGORY_SETS DEF
364: WHERE DEF.CATEGORY_SET_ID = CSET.CATEGORY_SET_ID
365: AND DEF.FUNCTIONAL_AREA_ID = 1;
366: END IF;