DBA Data[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: )