DBA Data[Home] [Help]

APPS.CN_QUOTA_ASSIGN_PUB dependencies on CN_QUOTA_ASSIGNS

Line 277: FROM cn_quota_assigns

273: l_quota_assign_id number := 0;
274: l_object_version_number number := 0;
275: CURSOR l_quota_assign_id_csr(p_cp_id number, p_pe_id number)IS
276: SELECT quota_assign_id, object_version_number, org_id
277: FROM cn_quota_assigns
278: WHERE comp_plan_id = p_cp_id
279: AND quota_id = p_pe_id;
280:
281: l_org_id NUMBER;

Line 497: FROM cn_quota_assigns

493: l_quota_assign_id number := 0;
494: l_object_version_number number := 0;
495: CURSOR l_quota_assign_id_csr(p_cp_id number, p_pe_id number)IS
496: SELECT quota_assign_id, object_version_number, org_id
497: FROM cn_quota_assigns
498: WHERE comp_plan_id = p_cp_id
499: AND quota_id = p_pe_id;
500:
501: l_org_id NUMBER;