APPS.CS_SERVICEREQUEST_UTIL dependencies on MTL_CATEGORY_SET_VALID_CATS

Line 3089: FROM mtl_category_set_valid_cats ic

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

Line 3150: FROM mtl_category_set_valid_cats

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