APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_DOC_USAGE_STATS

Line 2174: from iem_doc_usage_stats

2170: END LOOP;
2171: ELSIF nvl(l_search_type,' ')='CM' and l_cm_cat_id is not null then
2172: for v_item in c_item LOOP
2173: select count(*) into l_kb_rank
2174: from iem_doc_usage_stats
2175: where kb_doc_id=v_item.item_id;
2176: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
2177: p_init_msg_list=>'F' ,
2178: p_commit=>'F' ,

Line 4279: from iem_doc_usage_stats

4275: END LOOP;
4276: ELSIF nvl(l_search_type,' ')='CM' and l_cm_cat_id is not null then
4277: for v_item in c_item LOOP
4278: select count(*) into l_kb_rank
4279: from iem_doc_usage_stats
4280: where kb_doc_id=v_item.item_id;
4281: IEM_KB_RESULTS_PVT.create_item(p_api_version_number=>1.0,
4282: p_init_msg_list=>'F' ,
4283: p_commit=>'F' ,