APPS.IEM_DIAG_OES_RULE_PVT SQL Statements

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

Line: 62

   JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 64

	l_string := 'select email_user, domain, db_server_id, email_password, account_flag from iem_email_accounts';

Line: 66

	select db_link into l_apps_link from iem_db_connections where is_admin='O';

Line: 74

		IEM_DB_CONNECTIONS_PVT.select_item(
               		p_api_version_number =>1.0,
                 	p_db_server_id  =>l_account_rec.db_server_id,
               		p_is_admin =>'A',
  			x_db_link=>l_im_link1,
  			x_return_status =>l_stat,
  			x_msg_count    => l_count,
  			x_msg_data      => l_data);

Line: 105

		l_str := 'select count(*) from ' || l_rule_table || ' a, ' || l_account_table || ' b, ' || l_domain_table || ' c where b.objectid = a.account_id and b.domainid = c.objectid and c.qualifiedname=UPPER(:domain) and b.name = UPPER(:username)';

Line: 107

		l_str1 := 'select info1 from ' || l_rule_table || ' a, ' || l_account_table || ' b, ' || l_domain_table || ' c where b.objectid = a.account_id and b.domainid = c.objectid and c.qualifiedname=UPPER(:domain) and b.name = UPPER(:username)';

Line: 119

       			reportStr := 'no rows selected';

Line: 159

       					reportStr := 'no rows selected';

Line: 166

    				select length(l_rule_name) into l_length from dual;

Line: 174

    					select substr(l_rule_name, 35) into l_rule_apps_name from dual;