APPS.CN_QUOTA_ASSIGN_PVT dependencies on CN_QUOTAS_ALL

Line 225: FROM cn_quotas_all

221: IF (l_quota_id > 0 AND l_comp_plan_id > 0)
222: THEN
223: SELECT NAME
224: INTO l_pe_name
225: FROM cn_quotas_all
226: WHERE quota_id = l_quota_id;
227:
228: SELECT NAME
229: INTO l_cp_name

Line 561: FROM cn_quotas_all

557: IF (p_quota_assign.quota_sequence <> old_seq)
558: THEN
559: SELECT NAME
560: INTO l_pe_name
561: FROM cn_quotas_all
562: WHERE quota_id = l_quota_id;
563:
564: SELECT NAME
565: INTO l_cp_name

Line 580: FROM cn_quotas_all

576: ELSE IF (l_quota_id > 0 AND l_comp_plan_id > 0)
577: THEN
578: SELECT NAME
579: INTO l_pe_name
580: FROM cn_quotas_all
581: WHERE quota_id = l_quota_id;
582:
583: SELECT NAME
584: INTO l_cp_name

Line 611: FROM cn_quotas_all

607: );*/
608:
609: SELECT NAME
610: INTO l_pe_name
611: FROM cn_quotas_all
612: WHERE quota_id = l_old_quota_assign.quota_id;
613:
614: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_UNAS');
615: fnd_message.set_token ('PE_NAME', l_pe_name);

Line 804: FROM cn_quotas_all

800: IF (l_quota_id > 0 AND l_comp_plan_id > 0)
801: THEN
802: SELECT NAME
803: INTO l_pe_name
804: FROM cn_quotas_all
805: WHERE quota_id = l_quota_id;
806:
807: SELECT NAME
808: INTO l_cp_name