APPS.CSP_EXCESS_PARTS_PVT dependencies on MTL_CATEGORY_SETS

Line 355: FROM MTL_CATEGORY_SETS

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

Line 360: FROM MTL_CATEGORY_SETS CSET,

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