APPS.IEM_MSG_STAT_PUB dependencies on IEM_RT_MEDIA_ITEMS

Line 707: select rt_interaction_id into l_rt_interaction_id from iem_rt_media_items

703: x_return_status := FND_API.G_RET_STS_SUCCESS;
704:
705: -----------------------Code------------------------
706: BEGIN
707: select rt_interaction_id into l_rt_interaction_id from iem_rt_media_items
708: where rt_media_item_id = p_rt_mediaID;
709:
710: l_email_type := 'O';
711: select media_id into l_outbound_media_ID from iem_rt_media_items where email_type=l_email_type and

Line 711: select media_id into l_outbound_media_ID from iem_rt_media_items where email_type=l_email_type and

707: select rt_interaction_id into l_rt_interaction_id from iem_rt_media_items
708: where rt_media_item_id = p_rt_mediaID;
709:
710: l_email_type := 'O';
711: select media_id into l_outbound_media_ID from iem_rt_media_items where email_type=l_email_type and
712: rt_interaction_id = l_rt_interaction_id;
713: EXCEPTION
714: WHEN OTHERS THEN
715: NULL;

Line 721: select media_id into l_inbound_media_ID from iem_rt_media_items where email_type=l_email_type and

717:
718: BEGIN
719:
720: l_email_type := 'I';
721: select media_id into l_inbound_media_ID from iem_rt_media_items where email_type=l_email_type and
722: rt_interaction_id = l_rt_interaction_id;
723: EXCEPTION
724: WHEN OTHERS THEN
725: NULL;