APPS.IEM_SUGG_DOC_RANK_PVT dependencies on IEM_EMAIL_CLASSIFICATIONS

Line 50: from (select classification_id from iem_email_classifications

46: END IF;
47: x_return_status := FND_API.G_RET_STS_SUCCESS;
48: SAVEPOINT IEM_SUGG_PVT;
49: select * into l_class_id
50: from (select classification_id from iem_email_classifications
51: where message_id=p_message_id order by score desc)
52: where rownum=1;
53: l_rank:=0;
54: FOR v1 in c_top5 LOOP