27: and responsibility_id = fnd_profile.value('RESP_ID');
28: --
29: cursor c_status_group2 is
30: select status_group_id
31: from cs_incident_types_b
32: where incident_type_id = l_type_id;
33: --
34: cursor c_trans_ind is
35: select transition_ind
72: -- used when trans_id is NOT Y
73: l_lov_sttmnt3 := '
74: select st.incident_status_id, st.name, '' ''
75: from cs_incident_statuses st,
76: cs_incident_types_b typ,
77: cs_sr_allowed_statuses allowd_st
78: where typ.incident_type_id = ' || to_char(l_type_id) || '
79: and typ.status_group_id = allowd_st.status_group_id
80: and allowd_st.incident_status_id = st.incident_status_id