APPS.CN_GET_COMM_SUMM_DATA_PVT dependencies on CN_CAL_PER_INT_TYPES

Line 468: from cn_cal_per_int_types it, cn_period_statuses ps

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
470: and it.org_id = ps.org_id
471: and ps.period_year = a_period_year
472: and ps.org_id = p_org_id