DBA Data[Home] [Help]

APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_SRP_PLAN_ASSIGNS

Line 2237: FROM cn_srp_plan_assigns cnspa

2233: AND cnspa.payee_id = cnspg.salesrep_id
2234: --R12
2235: AND cnspa.org_id = cnp.org_id) OR EXISTS
2236: (SELECT 1
2237: FROM cn_srp_plan_assigns cnspa
2238: WHERE ((cnspa.start_date <= cnps.end_date) AND (cnps.start_date <= nvl(cnspa.end_date, cnps.start_date)))
2239: AND cnspa.salesrep_id = cnspg.salesrep_id
2240: --R12
2241: AND cnspa.org_id = cnp.org_id)));

Line 2322: FROM cn_srp_plan_assigns cnspa

2318: AND cnspa.payee_id = cnspg.salesrep_id
2319: --R12
2320: AND cnspa.org_id = cnp.org_id) OR EXISTS
2321: (SELECT 1
2322: FROM cn_srp_plan_assigns cnspa
2323: WHERE ((cnspa.start_date <= cnps.end_date) AND (cnps.start_date <= nvl(cnspa.end_date, cnps.start_date)))
2324: AND cnspa.salesrep_id = cnspg.salesrep_id
2325: --R12
2326: AND cnspa.org_id = cnp.org_id))); */