DBA Data[Home] [Help]

APPS.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on JTF_NOTES_VL

Line 908: from jtf_notes_vl

904: RETURN VARCHAR2 IS
905: l_first_note varchar2(2000) DEFAULT NULL;
906: CURSOR c_first_note(param_incident_id NUMBER) is
907: select notes
908: from jtf_notes_vl
909: where source_object_code = 'SR' and source_object_id =param_incident_id
910: order by creation_date;
911: begin
912: open c_first_note (p_incident_id);