APPS.CN_SRP_PERIODS_PVT dependencies on CN_QUOTA_ASSIGNS

Line 452: (SELECT quota_id FROM cn_quota_assigns

448: CURSOR c_quota_csr IS
449: (SELECT credit_type_id, quota_id
450: FROM cn_quotas_all
451: WHERE quota_id IN
452: (SELECT quota_id FROM cn_quota_assigns
453: WHERE comp_plan_id = p_comp_plan_id)
454: AND quota_id = nvl(p_quota_id, quota_id));
455:
456: