APPS.BIV_RT_SR_AGE_REPORT_PKG dependencies on CS_INCIDENT_SEVERITIES_VL

Line 290: FROM cs_incident_severities_vl a

286: l_label_2 VARCHAR2(20);
287: BEGIN
288: -- get severity type
289: SELECT a.name INTO l_label_1
290: FROM cs_incident_severities_vl a
291: WHERE a.incident_severity_id = fnd_profile.value('BIV:INC_SEVERITY_1');
292:
293: -- get "Severity"
294: SELECT attribute_label_long INTO l_label_2

Line 309: FROM cs_incident_severities_vl a

305: l_label_2 VARCHAR2(20);
306: BEGIN
307: -- get severity type
308: SELECT a.name INTO l_label_1
309: FROM cs_incident_severities_vl a
310: WHERE a.incident_severity_id = fnd_profile.value('BIV:INC_SEVERITY_2');
311:
312: -- get "Severity"
313: SELECT attribute_label_long INTO l_label_2

Line 328: FROM cs_incident_severities_vl a

324: l_label_2 VARCHAR2(20);
325: BEGIN
326: -- get severity type
327: SELECT a.name INTO l_label_1
328: FROM cs_incident_severities_vl a
329: WHERE a.incident_severity_id = fnd_profile.value('BIV:INC_SEVERITY_3');
330:
331: -- get "Severity"
332: SELECT attribute_label_long INTO l_label_2

Line 347: FROM cs_incident_severities_vl a

343: l_label_2 VARCHAR2(20);
344: BEGIN
345: -- get severity type
346: SELECT a.name INTO l_label_1
347: FROM cs_incident_severities_vl a
348: WHERE a.incident_severity_id = fnd_profile.value('BIV:INC_SEVERITY_4');
349:
350: -- get "Severity"
351: SELECT attribute_label_long INTO l_label_2

Line 366: FROM cs_incident_severities_vl a

362: l_label_2 VARCHAR2(20);
363: BEGIN
364: -- get severity type
365: SELECT a.name INTO l_label_1
366: FROM cs_incident_severities_vl a
367: WHERE a.incident_severity_id = fnd_profile.value('BIV:INC_SEVERITY_5');
368:
369: -- get "Severity"
370: SELECT attribute_label_long INTO l_label_2