eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_GET_COMM_SUMM_DATA dependencies on CN_SRP_PERIOD_QUOTAS

Line 173: from cn_srp_period_quotas spq, cn_quotas q

169: CURSOR ytd_quota_target_cur
170: (l_srp_plan_assign_id IN NUMBER,
171: l_quota_group_code IN VARCHAR) IS
172: select nvl(sum(itd_target),0) itd_target
173: from cn_srp_period_quotas spq, cn_quotas q
174: where srp_plan_assign_id = l_srp_plan_assign_id
175: and period_id = p_period_id
176: and q.quota_id = spq.quota_id
177: and q.quota_group_code = l_quota_group_code;

Line 187: FROM cn_srp_period_quotas cspq,

183: CURSOR ytd_cur(l_quota_group_code IN VARCHAR,
184: l_srp_plan_assign_id IN NUMBER) IS
185: SELECT sum(nvl(cspq.perf_achieved_itd,0)) ytd_credit,
186: sum(nvl(cspq.commission_payed_itd,0)) ytd_earnings
187: FROM cn_srp_period_quotas cspq,
188: cn_quotas quota
189: WHERE cspq.period_id = p_period_id
190: AND cspq.srp_plan_assign_id = l_srp_plan_assign_id
191: AND cspq.quota_id = quota.quota_id

Line 210: cn_srp_period_quotas cspq

206: SELECT sum(nvl(cspq.target_amount,0)) ptd_target,
207: sum(nvl(cspq.perf_achieved_ptd,0)) ptd_credit,
208: sum(nvl(cspq.commission_payed_ptd,0)) ptd_earnings
209: FROM cn_quotas quota,
210: cn_srp_period_quotas cspq
211: WHERE cspq.period_id = p_period_id
212: AND cspq.srp_plan_assign_id = l_srp_plan_assign_id
213: AND cspq.quota_id = quota.quota_id
214: AND quota.quota_group_code = l_quota_group_code