DBA Data[Home] [Help]

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))