APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_SRP_ROLES
Line 2447: FROM cn_srp_roles csr
2443: WHERE cqa.quota_id = p_plan_element.quota_id
2444: AND EXISTS (SELECT 1
2445: FROM cn_srp_plan_assigns cspa
2446: WHERE cspa.comp_plan_id = cqa.comp_plan_id AND EXISTS (SELECT 1 2447: FROM cn_srp_roles csr 2448: WHERE csr.salesrep_id = cspa.salesrep_id AND csr.role_id = 54));
2449:
2450: IF (l_payeechk > 0)
2451: THEN