APPS.IEX_CASE_OWNER_PUB SQL Statements

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

Line: 74

    SELECT DISTINCT party_id
	FROM iex_cases_all_b;

Line: 80

	SELECT ac.resource_id,0
	FROM  hz_customer_profiles hp, jtf_rs_resource_extns rs,ar_collectors ac
	WHERE hp.party_id = p_party_id
	and rs.resource_id = ac.resource_id
	and hp.collector_id = ac.collector_id
	and hp.cust_account_id=-1
	and hp.site_use_id is null
	and trunc(nvl(rs.end_date_active,sysdate)) >= trunc(sysdate)
	and rs.user_id is not null
	and ac.employee_id is not null
	and trunc(nvl(ac.inactive_date,sysdate)) >= trunc(sysdate)
	and nvl(ac.status,'A') = 'A'
	and nvl(hp.status,'A') = 'A'
	group by ac.resource_id;

Line: 96

	SELECT DISTINCT rs.resource_id, 0
	FROM as_rpt_managers_v m, as_accesses acc, jtf_rs_resource_extns rs
	WHERE m.person_id = acc.person_id
	AND m.manager_person_id = rs.source_id
	AND acc.customer_id = p_party_id
        AND rs.start_date_active <= sysdate
        AND rs.end_date_active > sysdate;*/

Line: 107

    SELECT count(1)
	FROM iex_cases_all_b
	WHERE party_id = p_party_id;

Line: 112

    SELECT cas_id
	FROM iex_cases_all_b
	WHERE party_id = p_party_id;

Line: 209

             iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'before update:index_of_resource=' || l_idx || ':resource=' || l_p_rs_id_tab(l_idx)
		      || ':assigned_count=' || l_p_rs_cnt_tab(l_idx)
		      || ':case_id=' || l_p_case_id_tab(i));

Line: 214

  	      UPDATE iex_cases_all_b
  	      SET owner_resource_id = l_p_rs_id_tab(l_idx)
  	      WHERE cas_id = l_p_case_id_tab(i);

Line: 222

             iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'after update:index_of_resource=' || l_idx || ':resource=' || l_p_rs_id_tab(l_idx)
		      || ':assigned_count=' || l_p_rs_cnt_tab(l_idx)
		      || ':case_id=' || l_p_case_id_tab(i));