APPS.CS_SR_CTX_PKG SQL Statements

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

Line: 23

     select tl.incident_id, tl.language, b.incident_type_id,
            b.inventory_item_id, tl.summary
     from cs_incidents_all_tl tl, cs_incidents_all_b b
     where tl.rowid = c_rowid
     and tl.incident_id = b.incident_id;

Line: 30

     select tl.notes, b.note_status, b.created_by
           ,tl.notes_detail
      from jtf_notes_tl tl, jtf_notes_b b
      where tl.jtf_note_id = b.jtf_note_id
      and b.source_object_code  = 'SR'
      and b.source_object_id = c_obj_id
      and b.note_status in ('E', 'I')
      and tl.language = c_lang;