[Home] [Help]
APPS.CN_SRP_QUOTA_ASSIGNS_PKG dependencies on CN_SRP_ROLES
Line 191: FROM cn_srp_roles csr
187: WHERE cspa.srp_plan_assign_id = p_srp_plan_assign_id
188: AND EXISTS
189: (
190: SELECT 1
191: FROM cn_srp_roles csr
192: WHERE csr.salesrep_id = cspa.salesrep_id
193: AND csr.org_id = cspa.org_id
194: and csr.role_id = 54
195: )