APPS.IEM_MIGRATION_PVT dependencies on IEM_EMAIL_SERVER_TYPES

Line 1385: from iem_email_servers a,iem_email_server_types b

1381: select to_number(decode(FND_PROFILE.VALUE_SPECIFIC('IEM_ACCOUNT_SENDER_NAME'),'ACCOUNT',0,1)) into
1382: l_sender_profile from dual;
1383: select dns_name,port
1384: into l_in_host,l_in_port
1385: from iem_email_servers a,iem_email_server_types b
1386: where a.server_type_id=b.email_server_type_id and
1387: b.email_server_type='IMAP' and
1388: a.server_group_id=v1.server_group_id;
1389:

Line 1392: from iem_email_servers a,iem_email_server_types b

1388: a.server_group_id=v1.server_group_id;
1389:
1390: select dns_name,port
1391: into l_out_host,l_out_port
1392: from iem_email_servers a,iem_email_server_types b
1393: where a.server_type_id=b.email_server_type_id and
1394: b.email_server_type='SMTP' and
1395: a.server_group_id=v1.server_group_id;
1396: if l_dblink is null then -- not required to get the dblink repeatedly