APPS.IEX_COLL_CAMP_SCHD_RPT_PKG SQL Statements

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

Line: 142

          SELECT DISTINCT COUNT(resource_id)
           INTO l_res_cnt
           FROM JTF_RS_RESOURCE_EXTNS
          WHERE source_id IN
          ( SELECT DISTINCT b.person_id
             FROM jtf_rs_rep_managers b,
            JTF_RS_RESOURCE_EXTNS a
            WHERE b.manager_person_id = a.source_id
          AND a.resource_id           = p_collector
          );

Line: 153

        l_res_qry  := '(select distinct resource_id '||
	'from '|| 'JTF_RS_RESOURCE_EXTNS '||
	'where source_id in (select distinct b.person_id '||
	'from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a '||
	'where b.manager_person_id = a.source_id '|| 'and a.resource_id = '||p_collector;

Line: 175

	   l_where:=l_where||' and (jii.source_code_id in (Select source_code_id '||
 	                     'from  ams_source_codes '||
			     'where arc_source_code_for =''CAMP'') '||
 	                     'OR jii.source_code_id is NULL)';

Line: 184

    select outcome_code
    into l_out_code
    from jtf_ih_outcomes_vl
    where outcome_id=p_outcome;

Line: 194

    select result_code
    into l_resl_code
    from jtf_ih_results_vl
    where result_id=p_result;

Line: 204

    select reason_code
    into l_res_code
    from jtf_ih_reasons_vl
    where reason_id=p_reason;

Line: 212

  /* l_where:=l_where||' and (ipd.campaign_sched_id in (Select source_code_id '||
  'from  ams_source_codes '||
  'where arc_source_code_for =''CAMP'') '||
  'OR IPD.campaign_sched_id is NULL)'; */

Line: 225

  l_query:='select jrrev.source_name Collector,amsc.source_code Campaign,jiov.outcome_code Outcome,'|| 'jires.result_code Result,jirea.reason_code Reason , count(*) Count '||
            'from '||
	    'jtf_ih_interactions jii,jtf_rs_resource_extns jrrev,'|| 'jtf_ih_outcomes_vl jiov,jtf_ih_results_vl jires,jtf_ih_reasons_vl jirea,ams_source_codes amsc '||
	    'where jii.resource_id= jrrev.resource_id(+) '||
	    'and jii.outcome_id= jiov.outcome_id(+) '||
	    'and jii.result_id= jires.result_id(+) '||
	    'and jii.reason_id= jirea.reason_id(+) '||
	    'and jii.source_code= amsc.source_code(+) ';

Line: 269

    select source_name
    into l_collector
    from jtf_rs_resource_extns
    where resource_id=p_collector;

Line: 278

    select source_code
    into l_campaign
    from ams_source_codes
    where source_code_id=p_campaign;

Line: 286

  select TRUNC(sysdate)
  into l_sysdate
  from dual;