[Home] [Help]
APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_SRP_PLAN_ASSIGNS
Line 2280: FROM cn_srp_plan_assigns cnspa
2276: AND cnspa.payee_id = cnspg.salesrep_id
2277: --R12
2278: AND cnspa.org_id = cnp.org_id) OR EXISTS
2279: (SELECT 1
2280: FROM cn_srp_plan_assigns cnspa
2281: WHERE ((cnspa.start_date <= cnps.end_date) AND (cnps.start_date <= nvl(cnspa.end_date, cnps.start_date)))
2282: AND cnspa.salesrep_id = cnspg.salesrep_id
2283: --R12
2284: AND cnspa.org_id = cnp.org_id)));