APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_SRP_PLAN_ASSIGNS

Line 2421: FROM cn_srp_plan_assigns cspa

2417: INTO l_payeechk
2418: FROM cn_quota_assigns cqa
2419: WHERE cqa.quota_id = p_plan_element.quota_id
2420: AND EXISTS (SELECT 1
2421: FROM cn_srp_plan_assigns cspa
2422: WHERE cspa.comp_plan_id = cqa.comp_plan_id AND EXISTS (SELECT 1
2423: FROM cn_srp_roles csr
2424: WHERE csr.salesrep_id = cspa.salesrep_id AND csr.role_id = 54));
2425: