APPS.CS_SR_FUL_PKG dependencies on JTF_NOTES_VL

Line 330: select notes from jtf_notes_vl

326: /*CURSOR inc_log_csr is
327: select substr(cs_sr_log_pkg.sr_log(p_incident_id),1,27000) log from dual; */
328:
329: CURSOR inc_notes_csr is
330: select notes from jtf_notes_vl
331: where source_object_id = p_incident_id and
332: note_type = l_note_type and
333: jtf_note_id = (select max(jtf_note_id) from jtf_notes_vl
334: where source_object_id = p_incident_id

Line 333: jtf_note_id = (select max(jtf_note_id) from jtf_notes_vl

329: CURSOR inc_notes_csr is
330: select notes from jtf_notes_vl
331: where source_object_id = p_incident_id and
332: note_type = l_note_type and
333: jtf_note_id = (select max(jtf_note_id) from jtf_notes_vl
334: where source_object_id = p_incident_id
335: and note_type = l_note_type);
336:
337: -- Bug fix for 2428307. Added cursor by pnkalari on 07/01/2002.