DBA Data[Home] [Help]

APPS.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on JTF_NOTES_VL

Line 909: from jtf_notes_vl

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