2198: SELECT 1
2199: INTO l_temp_count
2200: FROM SYS.DUAL
2201: WHERE NOT EXISTS (SELECT 1
2202: FROM cn_quota_assigns
2203: WHERE quota_id = p_plan_element.quota_id);
2204: EXCEPTION
2205: WHEN NO_DATA_FOUND
2206: THEN
2414: IF p_plan_element.payee_assign_flag = 'Y'
2415: THEN
2416: SELECT COUNT (*)
2417: INTO l_payeechk
2418: FROM cn_quota_assigns cqa
2419: WHERE cqa.quota_id = p_plan_element.quota_id
2420: AND EXISTS (SELECT 1
2421: FROM cn_srp_plan_assigns cspa
2422: WHERE cspa.comp_plan_id = cqa.comp_plan_id AND EXISTS (SELECT 1