APPS.CN_QUOTA_ASSIGN_PVT dependencies on CN_QUOTAS_V

Line 128: FROM cn_comp_plans c, cn_quotas_v q

124:
125: -- 3. quota dates must overlap plan dates
126: SELECT COUNT (1)
127: INTO l_temp_count
128: FROM cn_comp_plans c, cn_quotas_v q
129: WHERE c.comp_plan_id = p_quota_assign.comp_plan_id
130: AND q.quota_id = p_quota_assign.quota_id
131: AND GREATEST (c.start_date, q.start_date) <=
132: LEAST (NVL (c.end_date, g_end_of_time),

Line 471: FROM cn_comp_plans c, cn_quotas_v q

467:
468: -- 3. quota dates must overlap plan dates
469: SELECT COUNT (1)
470: INTO l_temp_count
471: FROM cn_comp_plans c, cn_quotas_v q
472: WHERE c.comp_plan_id = p_quota_assign.comp_plan_id
473: AND q.quota_id = p_quota_assign.quota_id
474: AND GREATEST (c.start_date, q.start_date) <=
475: LEAST (NVL (c.end_date, g_end_of_time),

Line 921: FROM cn_quota_assigns qa, cn_quotas_v q

917: SELECT q.NAME, q.description, q.start_date, q.end_date,
918: qa.quota_assign_id, qa.quota_id, qa.comp_plan_id,
919: NVL (qa.quota_sequence, 0) quota_sequence,
920: qa.object_version_number, qa.org_id
921: FROM cn_quota_assigns qa, cn_quotas_v q
922: WHERE qa.comp_plan_id = p_comp_plan_id
923: AND qa.quota_id = q.quota_id
924: ORDER BY quota_sequence;
925: BEGIN