DBA Data[Home] [Help]

APPS.BIV_VERSION_SPECIFIC_PKG dependencies on CS_INCIDENT_TYPES_B

Line 31: from cs_incident_types_b

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

Line 76: cs_incident_types_b typ,

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