APPS.IEM_EMAIL_PROC_PVT dependencies on JTF_IH_MEDIA_ITEM_LC_SEGS

Line 1363: from jtf_ih_media_item_lc_segs

1359: -- Calling Rules Engine for autoacknowledge
1360: IF l_post_rec.ih_media_item_id is not null then --chk autoack for rerouted message
1361: l_autoack_count:=0;
1362: select count(*) into l_autoack_count
1363: from jtf_ih_media_item_lc_segs
1364: where media_id=l_post_rec.ih_media_item_id
1365: and MILCS_TYPE_ID=29;
1366: END IF;
1367: IF l_autoack_count=0 then --not auto acked yet for this message