APPS.IEO_CONCURRENT_PUB SQL Statements

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

Line: 127

	select server_id, status, trunc((sysdate-last_update_date)*24*60*60) diff1
	from ieo_svr_rt_info
	where ABS(status) >= 4;

Line: 306

            select node_id, priority
            from ieo_svr_node_assignments
            where server_id = l_server_id
            order by priority;

Line: 319

                select status into l_node_status
                from ieo_nodes
                where node_id = l_node_id;

Line: 326

                  select trunc((sysdate-last_update_date)*24*60*60) into diff2
                  from ieo_nodes
                  where node_id = l_node_id;

Line: 333

    		        select server_name into l_server_name
    		        from ieo_svr_servers
    		        where server_id = l_server_id;