APPS.IEM_CLIENT_PUB dependencies on IEM_OUTBOUND_MSG_STATS

Line 2942: from iem_outbound_msg_stats

2938: else
2939: begin
2940: l_use_suggested := 0;
2941: select count(OUTBOUND_MSG_STATS_ID) into l_use_suggested
2942: from iem_outbound_msg_stats
2943: where media_id = l_ob_media_id
2944: and USES_SUGGESTIONS_Y_N = 'Y';
2945:
2946: if ( l_use_suggested > 0 ) then