APPS.CN_QUOTA_RULES_GRP dependencies on CN_REVENUE_CLASSES

Line 186: FROM cn_revenue_classes

182: SELECT COUNT (*)
183: INTO l_same_pe
184: FROM cn_quota_rules qr
185: WHERE qr.revenue_class_id = (SELECT revenue_class_id
186: FROM cn_revenue_classes
187: WHERE NAME = p_pe_rec.rev_class_name
188: AND org_id = p_pe_rec.org_id) AND qr.quota_id = p_pe_rec.quota_id;
189:
190: IF l_same_pe <> 0

Line 284: FROM cn_revenue_classes

280: SELECT COUNT (*)
281: INTO l_same_pe
282: FROM cn_quota_rules qr
283: WHERE qr.revenue_class_id = (SELECT revenue_class_id
284: FROM cn_revenue_classes
285: WHERE revenue_class_id = x_rev_class_id_old) AND qr.quota_id = p_new_pe_rec.quota_id;
286:
287: IF l_same_pe = 0
288: THEN

Line 305: FROM cn_revenue_classes

301: SELECT COUNT (*)
302: INTO l_same_pe
303: FROM cn_quota_rules qr
304: WHERE qr.revenue_class_id = (SELECT revenue_class_id
305: FROM cn_revenue_classes
306: WHERE revenue_class_id = p_new_pe_rec.rev_class_id) AND qr.quota_id = p_new_pe_rec.quota_id;
307:
308: IF l_same_pe > 0
309: THEN