4608: ANd lookup_code like 'ACK%';
4609: l_index number;
4610: l_sender_name varchar2(250);
4611: l_qual_tbl IEM_OUTBOX_PROC_PUB.QualifierRecordList;
4612: l_from_name iem_email_accounts.from_name%type;
4613: l_reply_address iem_email_accounts.reply_to_address%type;
4614: begin
4615: select from_name,reply_to_address
4616: INTO l_from_name,l_reply_address
4609: l_index number;
4610: l_sender_name varchar2(250);
4611: l_qual_tbl IEM_OUTBOX_PROC_PUB.QualifierRecordList;
4612: l_from_name iem_email_accounts.from_name%type;
4613: l_reply_address iem_email_accounts.reply_to_address%type;
4614: begin
4615: select from_name,reply_to_address
4616: INTO l_from_name,l_reply_address
4617: from IEM_MSTEMAIL_ACCOUNTS