304: -- cursor to fetch the SR Type id of the SR whose task owner is
305: -- getting assigned.
306: cursor get_sr_type ( c_incident_id IN NUMBER ) is
307: select incident_type_id
308: from cs_incidents_all_b
309: where incident_id = c_incident_id;
310:
311: l_incident_type_id NUMBER;
312:
466:
467: -- cursor to fetch the SR Type id of the SR associated to the task
468: cursor get_sr_type ( c_incident_id IN NUMBER ) is
469: select incident_type_id
470: from cs_incidents_all_b
471: where incident_id = c_incident_id;
472:
473: l_incident_type_id NUMBER;
474: