APPS.CSP_PLANNER_NOTIFICATIONS dependencies on MTL_CATEGORY_SETS

Line 338: FROM MTL_CATEGORY_SETS

334: /* Validate cat set and MCAT struct */
335: IF (p_category_set_id is not null and p_category_struct_id is not null) then
336: SELECT STRUCTURE_ID
337: into l_mcat_struct_id
338: FROM MTL_CATEGORY_SETS
339: WHERE CATEGORY_SET_ID = p_category_set_id;
340: ELSE
341: SELECT CSET.CATEGORY_SET_ID, CSET.STRUCTURE_ID
342: INTO l_category_set_id, l_mcat_struct_id

Line 343: FROM MTL_CATEGORY_SETS CSET,

339: WHERE CATEGORY_SET_ID = p_category_set_id;
340: ELSE
341: SELECT CSET.CATEGORY_SET_ID, CSET.STRUCTURE_ID
342: INTO l_category_set_id, l_mcat_struct_id
343: FROM MTL_CATEGORY_SETS CSET,
344: MTL_DEFAULT_CATEGORY_SETS DEF
345: WHERE DEF.CATEGORY_SET_ID = CSET.CATEGORY_SET_ID
346: AND DEF.FUNCTIONAL_AREA_ID = 1;
347: END IF;

Line 1987: FROM MTL_CATEGORY_SETS

1983: /* Validate cat set and MCAT struct */
1984: IF p_item_rec.category_set_id is not null then
1985: SELECT STRUCTURE_ID
1986: into l_mcat_struct_id
1987: FROM MTL_CATEGORY_SETS
1988: WHERE CATEGORY_SET_ID = p_item_rec.category_set_id;
1989: ELSE
1990: SELECT CSET.CATEGORY_SET_ID, CSET.STRUCTURE_ID
1991: INTO l_category_set_id, l_mcat_struct_id

Line 1992: FROM MTL_CATEGORY_SETS CSET,

1988: WHERE CATEGORY_SET_ID = p_item_rec.category_set_id;
1989: ELSE
1990: SELECT CSET.CATEGORY_SET_ID, CSET.STRUCTURE_ID
1991: INTO l_category_set_id, l_mcat_struct_id
1992: FROM MTL_CATEGORY_SETS CSET,
1993: MTL_DEFAULT_CATEGORY_SETS DEF
1994: WHERE DEF.CATEGORY_SET_ID = CSET.CATEGORY_SET_ID
1995: AND DEF.FUNCTIONAL_AREA_ID = 1;
1996: END IF;