APPS.CN_GET_COMM_SUMM_DATA_PVT dependencies on CN_SRP_QUOTA_ASSIGNS

Line 465: from cn_srp_quota_assigns sqa,

461: -- Annual Subquery
462: -- To get Annual Quota Target and percent
463: CURSOR annual_quota_cur(a_period_year number) IS
464: SELECT nvl(sum(nvl(sqa.target * it.ct,0)),0) target
465: from cn_srp_quota_assigns sqa,
466: cn_quotas q,
467: (select count(distinct interval_number) ct, it.interval_type_id
468: from cn_cal_per_int_types it, cn_period_statuses ps
469: where it.cal_period_id = ps.period_id