DBA Data[Home] [Help]

APPS.CN_UPG_PMT_TRXNS_PKG dependencies on CN_SRP_PLAN_ASSIGNS_ALL

Line 264: from cn_srp_plan_assigns_all pln

260: case
261: when pln.end_date between p.start_date and p.end_date then pln.end_date
262: else null
263: end
264: from cn_srp_plan_assigns_all pln
265: where srp_plan_assign_id =
266: (select srp_plan_assign_id
267: from cn_srp_period_quotas_all
268: where salesrep_id = pmt.credited_salesrep_id