APPS.CS_KB_KWIC_UTIL SQL Statements

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

Line: 219

      l_distinct_words.DELETE; -- clear out keyword map.

Line: 437

     SELECT notes, notes_detail
      FROM jtf_notes_vl
      WHERE source_object_code  = 'SR'
      AND source_object_id = c_obj_id
      AND note_status <> 'P'; -- IN ('E', 'I'); ignore private notes

Line: 499

      SELECT e.name, e.description
	   FROM cs_kb_set_eles b, cs_kb_elements_vl e
        WHERE e.element_id = b.element_id
		 AND b.set_id = p_set_id
		 AND e.status = 'PUBLISHED'
		 AND e.access_level >= Cs_Kb_Security_Pvt.GET_STMT_VISIBILITY_POSITION;