APPS.IEM_EMAIL_PROC_PVT dependencies on JTF_IH_MEDIA_ITEM_LC_SEGS

Line 940: from jtf_ih_media_item_lc_segs

936: -- Calling Rules Engine for autoacknowledge
937: IF l_post_rec.ih_media_item_id is not null then --chk autoack for rerouted message
938: l_autoack_count:=0;
939: select count(*) into l_autoack_count
940: from jtf_ih_media_item_lc_segs
941: where media_id=l_post_rec.ih_media_item_id
942: and MILCS_TYPE_ID=29;
943: END IF;
944: IF l_autoack_count=0 then --not auto acked yet for this message