APPS.IEM_TEXT_PVT dependencies on IEM_MS_MSGBODYS

Line 586: cursor c1 is select value,type from iem_ms_msgbodys

582: x_status out nocopy varchar2) IS
583: l_data clob;
584: l_text varchar2(32767):=' ';
585: l_text1 varchar2(32767):=' ';
586: cursor c1 is select value,type from iem_ms_msgbodys
587: where message_id=p_message_id
588: order by order_id;
589: l_html_flag number;
590: l_index number;