DBA Data[Home] [Help]

APPS.CN_SRP_PMT_PLANS_PUB dependencies on CN_QUOTAS

Line 172: FROM cn_srp_plan_assigns cspa, cn_srp_quota_assigns csqa , cn_quotas cq

168: -- the date range for credit_type_id check.
169: CURSOR get_quota_ids_csr (l_salesrep_id NUMBER,
170: l_start_date DATE, l_end_date DATE) IS
171: SELECT cq.quota_id,cq.credit_type_id
172: FROM cn_srp_plan_assigns cspa, cn_srp_quota_assigns csqa , cn_quotas cq
173: WHERE cspa.salesrep_id = l_salesrep_id
174: AND cspa.start_date <= l_start_date
175: --Bug 3432689 by Julia Huang on 4/29/04.
176: --AND nvl(l_end_date,l_null_date) <= nvl(cspa.end_date,l_null_date)