APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_QUOTA_ASSIGNS

Line 2226: FROM cn_quota_assigns

2222: SELECT 1
2223: INTO l_temp_count
2224: FROM SYS.DUAL
2225: WHERE NOT EXISTS (SELECT 1
2226: FROM cn_quota_assigns
2227: WHERE quota_id = p_plan_element.quota_id);
2228: EXCEPTION
2229: WHEN NO_DATA_FOUND
2230: THEN

Line 2442: FROM cn_quota_assigns cqa

2438: IF p_plan_element.payee_assign_flag = 'Y'
2439: THEN
2440: SELECT COUNT (*)
2441: INTO l_payeechk
2442: FROM cn_quota_assigns cqa
2443: WHERE cqa.quota_id = p_plan_element.quota_id
2444: AND EXISTS (SELECT 1
2445: FROM cn_srp_plan_assigns cspa
2446: WHERE cspa.comp_plan_id = cqa.comp_plan_id AND EXISTS (SELECT 1