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