109: l_incident_date DATE := NULL;
110: --
111: CURSOR get_incident_date IS
112: SELECT incident_date
113: FROM per_work_incidents pwi
114: WHERE pwi.incident_id = p_incident_id;
115: --
116: BEGIN
117: --
689: -- Declare Curors
690: --
691: CURSOR c_incident_id IS
692: SELECT incident_id
693: FROM per_work_incidents pwi
694: WHERE pwi.incident_id = p_incident_id;
695: --
696: -- Declare local variables
697: --