APPS.CN_ROLE_PMT_PLANS_PVT dependencies on CN_SALESREPS

Line 825: from cn_srp_roles csr, cn_salesreps cs

821: ;
822: */
823: CURSOR l_cur (l_org_id cn_pmt_plans.org_id%TYPE) IS
824: select csr.*
825: from cn_srp_roles csr, cn_salesreps cs
826: where csr.role_id = p_role_id
827: and csr.salesrep_id = cs.salesrep_id
828: and csr.org_id = cs.org_id
829: and csr.org_id = l_org_id;