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 1984: FROM MTL_CATEGORY_SETS

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

Line 1989: FROM MTL_CATEGORY_SETS CSET,

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