APPS.AHL_PRD_NONROUTINE_PVT dependencies on MFG_LOOKUPS

Line 1285: mfg_lookups mfl

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))
1289: AND trunc(nvl(csv.end_date_active,sysdate));