DBA Data[Home] [Help]

APPS.AHL_PRD_NONROUTINE_PVT dependencies on CS_INCIDENT_SEVERITIES_VL

Line 1284: FROM cs_incident_severities_vl csv,

1280: */
1281:
1282: CURSOR cs_sr_severity_validate(p_severity_id IN NUMBER) IS
1283: SELECT csv.incident_severity_id
1284: FROM cs_incident_severities_vl csv,
1285: mfg_lookups mfl
1286: WHERE csv.incident_severity_id = p_severity_id
1287: AND mfl.lookup_type = 'WIP_EAM_ACTIVITY_PRIORITY'
1288: AND trunc(sysdate) between trunc(nvl(csv.start_date_active,sysdate))