APPS.AHL_UMP_NONROUTINES_PVT dependencies on CS_INCIDENT_STATUSES_VL

Line 2935: FROM cs_incident_statuses_vl

2931: THEN
2932: BEGIN
2933: SELECT incident_status_id
2934: INTO p_x_nonroutine_rec.status_id
2935: FROM cs_incident_statuses_vl
2936: WHERE name = p_x_nonroutine_rec.status_name and
2937: trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and trunc(nvl(end_date_active, sysdate));
2938: EXCEPTION
2939: WHEN NO_DATA_FOUND THEN