DBA Data[Home] [Help]

APPS.IEM_DIAG_EMC_SETUP_PVT dependencies on IEM_EMAIL_SERVERS

Line 71: select count(*) into l_imap_count from iem_email_servers where server_type_id=10001;

67: select count(*) into l_oraoffice_count from iem_db_connections where is_admin='P';
68: select count(*) into l_apps_count from iem_db_connections where is_admin='O';
69:
70: -- Email Servers
71: select count(*) into l_imap_count from iem_email_servers where server_type_id=10001;
72: select count(*) into l_smtp_count from iem_email_servers where server_type_id=10002;
73:
74: -- Email Accounts
75: select count(*) into l_a_account_count from iem_email_accounts where account_flag = 'A';

Line 72: select count(*) into l_smtp_count from iem_email_servers where server_type_id=10002;

68: select count(*) into l_apps_count from iem_db_connections where is_admin='O';
69:
70: -- Email Servers
71: select count(*) into l_imap_count from iem_email_servers where server_type_id=10001;
72: select count(*) into l_smtp_count from iem_email_servers where server_type_id=10002;
73:
74: -- Email Accounts
75: select count(*) into l_a_account_count from iem_email_accounts where account_flag = 'A';
76: select count(*) into l_i_account_count from iem_email_accounts where account_flag = 'I';