APPS.CN_GET_COMM_SUMM_DATA dependencies on CN_SRP_QUOTA_ASSIGNS

Line 160: from cn_srp_quota_assigns sqa,

156: CURSOR annual_quota_cur
157: (l_srp_plan_assign_id IN NUMBER,
158: l_quota_group_code IN VARCHAR) IS
159: SELECT nvl(sum(sqa.target),0) target
160: from cn_srp_quota_assigns sqa,
161: cn_quotas q
162: where sqa.srp_plan_assign_id = l_srp_plan_assign_id
163: and sqa.quota_id = q.quota_id
164: and q.quota_group_code = l_quota_group_code;