APPS.AHL_REPAIR_CATEGORIES_PVT dependencies on CS_INCIDENT_URGENCIES_VL

Line 41: FROM cs_incident_urgencies_vl

37: sru_id in number
38: )
39: IS
40: SELECT name
41: FROM cs_incident_urgencies_vl
42: WHERE incident_urgency_id = sru_id AND
43: trunc(sysdate) >= trunc(nvl(start_date_active, sysdate)) AND
44: trunc(sysdate) < trunc(nvl(end_date_active, sysdate + 1));
45:

Line 52: FROM cs_incident_urgencies_vl

48: sr_name in varchar2
49: )
50: IS
51: SELECT incident_urgency_id
52: FROM cs_incident_urgencies_vl
53: WHERE name = sr_name AND
54: trunc(sysdate) >= trunc(nvl(start_date_active, sysdate)) AND
55: trunc(sysdate) < trunc(nvl(end_date_active, sysdate + 1));
56:

Line 153: FROM cs_incident_urgencies_vl cssr , ahl_repair_categories repcat

149: WHERE repair_category_id = p_x_repair_category_tbl(i).repair_category_id;
150: ELSE
151: SELECT cssr.name
152: INTO p_x_repair_category_tbl(i).incident_urgency_name
153: FROM cs_incident_urgencies_vl cssr , ahl_repair_categories repcat
154: WHERE repcat.sr_urgency_id = cssr.incident_urgency_id AND
155: repcat.repair_category_id = p_x_repair_category_tbl(i).repair_category_id;
156:
157: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MEL_CDL_REPCAT_ATASEQ_DEL');