APPS.CS_SERVICEREQUEST_UTIL dependencies on MTL_CATEGORY_SET_VALID_CATS

Line 3091: FROM mtl_category_set_valid_cats ic

3087: IF (p_category_id IS NOT NULL AND
3088: l_profile IS NOT NULL ) THEN
3089: SELECT 'x' INTO l_dummy
3090: --FROM mtl_item_categories ic
3091: FROM mtl_category_set_valid_cats ic
3092: WHERE ic.category_id = p_category_id
3093: AND ic.category_set_id = l_profile;
3094: --AND ic.organization_id = CS_STD.Get_Item_Valdn_Orgzn_Id;
3095: ELSE

Line 3152: FROM mtl_category_set_valid_cats

3148: IF (p_inventory_item_id IS NULL OR
3149: p_inventory_item_id = FND_API.G_MISS_NUM) THEN
3150: l_validation := 'C';
3151: SELECT 'x' INTO l_dummy
3152: FROM mtl_category_set_valid_cats
3153: WHERE category_id = p_category_id
3154: AND category_set_id = p_category_set_id;
3155: ELSIF (p_inventory_item_id IS NOT NULL) THEN
3156: l_validation := 'I';