APPS.IEM_CLIENT_PUB dependencies on IEM_OUTBOUND_MSG_STATS

Line 2880: from iem_outbound_msg_stats

2876: else
2877: begin
2878: l_use_suggested := 0;
2879: select count(OUTBOUND_MSG_STATS_ID) into l_use_suggested
2880: from iem_outbound_msg_stats
2881: where media_id = l_ob_media_id
2882: and USES_SUGGESTIONS_Y_N = 'Y';
2883:
2884: if ( l_use_suggested > 0 ) then