APPS.CN_COMP_PLAN_PUB dependencies on CN_QUOTAS_V

Line 50: cn_quotas_v q,

46: COUNT (DISTINCT de.value_external_id)
47: FROM cn_dim_explosion de,
48: cn_quota_rules qr,
49: cn_quota_assigns qa,
50: cn_quotas_v q,
51: cn_dim_hierarchies dh
52: WHERE dh.header_dim_hierarchy_id = l_rev_class_hierarchy_id
53: AND ( ( q.end_date IS NULL
54: AND NVL (TRUNC (dh.end_date), TRUNC (q.start_date)) >=

Line 109: FROM cn_quotas_v

105: SELECT quota_id, quota_type_code, start_date,
106: end_date
107: INTO x_pe_id, l_quota_type_code, l_quota_start_date,
108: l_quota_end_date
109: FROM cn_quotas_v
110: WHERE NAME = p_pe_name AND org_id = p_org_id ;
111: EXCEPTION
112: WHEN NO_DATA_FOUND
113: THEN