APPS.AHL_PRD_NONROUTINE_PVT dependencies on CS_INCIDENT_SEVERITIES_VL
Line 1421: FROM cs_incident_severities_vl csv,
1417: */
1418:
1419: CURSOR cs_sr_severity_validate(p_severity_id IN NUMBER) IS
1420: SELECT csv.incident_severity_id 1421: FROM cs_incident_severities_vl csv, 1422: mfg_lookups mfl
1423: WHERE csv.incident_severity_id = p_severity_id
1424: AND mfl.lookup_type = 'WIP_EAM_ACTIVITY_PRIORITY'
1425: AND trunc(sysdate) between trunc(nvl(csv.start_date_active,sysdate))