APPS.CS_INCIDENTLINKS_UTIL SQL Statements

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

Line: 20

   select link_type_id
   from   cs_sr_link_types_b
   where  link_type_id = p_link_type_id
   and    SYSDATE between nvl(start_date_active, SYSDATE)
		      and nvl(end_date_active  , SYSDATE);

Line: 82

   select count(*)
   into   l_dummy
   from   cs_sr_link_valid_obj
   where  subject_type = p_subject_type
   and    object_type  = p_object_type
   and    link_type_id = p_link_type_id
   and    SYSDATE between nvl(start_date_active, SYSDATE)
		      and nvl(end_date_active  , SYSDATE );

Line: 104

      select count(*)
      into   l_dummy
      from   cs_sr_link_valid_obj
      where  subject_type = p_object_type
      and    object_type  = p_subject_type
      and    link_type_id = ( select reciprocal_link_type_id
			      from   cs_sr_link_types_b
			      where  link_type_id = p_link_type_id )
      and    SYSDATE between nvl(start_date_active, SYSDATE)
		         and nvl(end_date_active  , SYSDATE );

Line: 166

   select select_id, select_name, from_table, name
   from   jtf_objects_vl
   where  object_code = c_object_code;

Line: 170

   l_sub_select_id           varchar2(90);

Line: 171

   l_sub_select_name         varchar2(90);

Line: 179

   l_obj_select_id           varchar2(90);

Line: 180

   l_obj_select_name         varchar2(90);

Line: 196

      l_sub_select_id, l_sub_select_name, l_sub_from_table, x_subject_type_name;

Line: 212

   elsif ( l_sub_select_name is null ) then
      close get_jtf_details;

Line: 234

      l_obj_select_id, l_obj_select_name, l_obj_from_table, x_object_type_name;

Line: 251

   elsif ( l_obj_select_name is null ) then
      close get_jtf_details;

Line: 276

   l_sql_stmnt := 'select max(' || l_sub_select_name || ' ) from ' || l_sub_from_table
                                || ' where ' || l_sub_select_id || ' = :p1 ' ;

Line: 300

   IF (l_obj_select_name is NOT NULL) THEN
   l_sql_stmnt := 'select max(' || l_obj_select_name || ' ) from ' || l_obj_from_table
		  || ' where ' || l_obj_select_id || ' = :p1 ' ;

Line: 306

      l_sql_stmnt := l_sql_stmnt || ' and ' || l_obj_select_name || ' = :p2 ';

Line: 332

   END IF; -- p_obj_select_name is not null

Line: 373

   select count(*)
   into   l_dummy
   from   cs_incident_links
   where  subject_id   = p_subject_id
   and    subject_type = p_subject_type
   and    object_id    = p_object_id
   and    object_type  = p_object_type
   and    SYSDATE between nvl(start_date_active   , SYSDATE)
		      and nvl(end_date_active - 1 , SYSDATE);

Line: 438

   select object_id
   from   cs_incident_links
   start  with (     subject_id   = p_object_id
                 and subject_type = p_object_type
 		 and link_type_id = p_link_type_id
		 and SYSDATE between nvl(start_date_active, SYSDATE)
				 and nvl(end_date_active,   SYSDATE) )
   connect by  prior object_id          = subject_id
   and         prior object_type        = subject_type
   and         prior link_type_id       = link_type_id
   and         SYSDATE between nvl(start_date_active, SYSDATE)
			   and nvl(end_date_active,   SYSDATE);

Line: 479

	 select max(name)
	 into   l_link_type_name
	 from   cs_sr_link_types_vl
	 where  link_type_id = p_link_type_id;

Line: 559

   select object_type, object_number
   from   cs_incident_links
   where  subject_id   = c_sub_obj_id
   and    subject_type = c_sub_obj_type
   and    link_type_id = 3     -- Duplicate Of
   and    SYSDATE between nvl(start_date_active, SYSDATE)
		      and nvl(end_date_active - 1,   SYSDATE);

Line: 580

   select link_type_id
   from   cs_incident_links
   where  subject_id    = c_sub_obj_id
   and    subject_type  = c_sub_obj_type
   and    link_type_id in (1, 2, 3, 4) --causals and Orig/Dup link type ids.
   and    SYSDATE between nvl(start_date_active, SYSDATE)
		      and nvl(end_date_active - 1,   SYSDATE);

Line: 592

   select name
   from   cs_sr_link_types_vl
   where  link_type_id = c_link_type_id;

Line: 614

      select name
      into   l_object_type_name
      from   jtf_objects_vl
      where  object_code = c1rec.object_type;

Line: 642

         select name
         into   l_object_type_name
         from   jtf_objects_vl
         where  object_code = c1rec.object_type;

Line: 673

	    select max(name)
	    into   l_new_link_type_name
	    from   cs_sr_link_types_vl
	    where  link_type_id = p_link_type_id;

Line: 678

	    select max(name)
	    into   l_existing_link_type_name
	    from   cs_sr_link_types_vl
	    where  link_type_id = c2rec.link_type_id;

Line: 706

	    select max(name)
	    into   l_new_link_type_name
	    from   cs_sr_link_types_vl
	    where  link_type_id = p_link_type_id;

Line: 711

	    select max(name)
	    into   l_existing_link_type_name
	    from   cs_sr_link_types_vl
	    where  link_type_id = c2rec.link_type_id;

Line: 761

   select responsibility_name
   from   fnd_responsibility_vl
   where  responsibility_id = sys_context('FND', 'RESP_ID')
   and    application_id    = sys_context('FND', 'RESP_APPL_ID');

Line: 771

   select incident_number
   from   cs_incidents_all_b
   where  incident_id = p_incident_id;

Line: 781

   select count(*)
   into   l_dummy
   from   cs_incidents_b_sec
   where  incident_id = p_incident_id;