APPS.IEM_DIAG_EMC_SETUP_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 54

   JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 60

		select count(*) into l_server_group_count from iem_server_groups;

Line: 63

		select count(*) into l_db_count from iem_db_servers;

Line: 66

		select count(*) into l_oo_count from iem_db_connections where is_admin='A';

Line: 67

		select count(*) into l_oraoffice_count from iem_db_connections where is_admin='P';

Line: 68

		select count(*) into l_apps_count from iem_db_connections where is_admin='O';

Line: 71

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

Line: 72

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

Line: 75

		select count(*) into l_a_account_count from iem_email_accounts where account_flag = 'A';

Line: 76

		select count(*) into l_i_account_count from iem_email_accounts where account_flag = 'I';