DBA Data[Home] [Help]

APPS.CN_COMMISSION_CALC_PVT dependencies on CN_SRP_PERIOD_QUOTAS

Line 193: FROM cn_srp_period_quotas cspq

189: CURSOR periodquotas_cr(p_srp_plan_assign_id NUMBER, p_salesrep_id NUMBER, p_period_id NUMBER, p_quota_id NUMBER) IS
190: SELECT nvl(cspq.input_achieved_itd,0) input_achieved_itd
191: , nvl(cspq.itd_TARGET,0) target_itd
192: , nvl(cspq.target_amount,0) target_amount
193: FROM cn_srp_period_quotas cspq
194: WHERE cspq.srp_plan_assign_id = p_srp_plan_assign_id
195: AND cspq.salesrep_id = p_salesrep_id
196: AND cspq.quota_id = p_quota_id
197: AND cspq.period_id = p_period_id;