APPS.BIV_VERSION_SPECIFIC_PKG dependencies on CS_SR_TYPE_MAPPING

Line 14: l_status_group_id cs_sr_type_mapping.status_group_id % type;

10: p_sr_rec.last_update_program_code := 'BIV_SR_UPDATE';
11: end;
12: procedure status_lov(p_sr_id number,
13: p_lov_sttmnt out nocopy varchar2) as
14: l_status_group_id cs_sr_type_mapping.status_group_id % type;
15: l_type_id cs_incidents_all_b.incident_type_id % type;
16: l_old_status_id cs_incident_statuses_b.incident_status_id % type;
17: --
18: cursor c_type is

Line 25: from cs_sr_type_mapping

21: where incident_id = p_sr_id;
22: ---
23: cursor c_status_group1 is
24: select status_group_id
25: from cs_sr_type_mapping
26: where incident_type_id = l_type_id
27: and responsibility_id = fnd_profile.value('RESP_ID');
28: --
29: cursor c_status_group2 is