APPS.CN_QUOTA_CATEGORIES_PUB dependencies on CN_ROLE_QUOTA_CATES

Line 148: -- cn_role_quota_cates table

144: RAISE FND_API.G_EXC_ERROR;
145: END IF;
146:
147: -- check whether this quota_category_id is already assigned
148: -- cn_role_quota_cates table
149: SELECT count(quota_category_id)
150: INTO l_count
151: FROM cn_role_quota_cates
152: WHERE quota_category_id = p_rec.quota_category_id;

Line 151: FROM cn_role_quota_cates

147: -- check whether this quota_category_id is already assigned
148: -- cn_role_quota_cates table
149: SELECT count(quota_category_id)
150: INTO l_count
151: FROM cn_role_quota_cates
152: WHERE quota_category_id = p_rec.quota_category_id;
153:
154: IF (l_count > 0) THEN
155: SELECT NAME

Line 257: -- cn_role_quota_cates table

253: FND_MSG_PUB.ADD;
254: RAISE FND_API.G_EXC_ERROR;
255: END IF;
256: -- check whether this quota_category_id is already assigned
257: -- cn_role_quota_cates table
258: SELECT count(quota_category_id)
259: INTO l_count
260: FROM cn_role_quota_cates
261: WHERE quota_category_id = p_quota_category_id;

Line 260: FROM cn_role_quota_cates

256: -- check whether this quota_category_id is already assigned
257: -- cn_role_quota_cates table
258: SELECT count(quota_category_id)
259: INTO l_count
260: FROM cn_role_quota_cates
261: WHERE quota_category_id = p_quota_category_id;
262:
263: IF (l_count > 0) THEN
264: SELECT NAME