APPS.AHL_UMP_NONROUTINES_PVT dependencies on CS_INCIDENT_STATUSES_VL

Line 3052: FROM cs_incident_statuses_vl

3048: THEN
3049: BEGIN
3050: SELECT incident_status_id
3051: INTO p_x_nonroutine_rec.status_id
3052: FROM cs_incident_statuses_vl
3053: WHERE name = p_x_nonroutine_rec.status_name and
3054: trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and trunc(nvl(end_date_active, sysdate));
3055: EXCEPTION
3056: WHEN NO_DATA_FOUND THEN