32: where incident_type_id = l_type_id;
33: --
34: cursor c_trans_ind is
35: select transition_ind
36: from cs_sr_status_groups_b
37: where status_group_id = l_status_group_id
38: and sysdate between nvl(start_date,sysdate-1) and nvl(end_date,sysdate+1);
39: l_trans_id cs_sr_status_groups_b.transition_ind % type;
40: l_lov_sttmnt1 varchar2(2000);
35: select transition_ind
36: from cs_sr_status_groups_b
37: where status_group_id = l_status_group_id
38: and sysdate between nvl(start_date,sysdate-1) and nvl(end_date,sysdate+1);
39: l_trans_id cs_sr_status_groups_b.transition_ind % type;
40: l_lov_sttmnt1 varchar2(2000);
41: l_lov_sttmnt2 varchar2(2000);
42: l_lov_sttmnt3 varchar2(2000);
43: begin