DBA Data[Home] [Help]

APPS.AHL_PRD_NONROUTINE_PVT dependencies on MFG_LOOKUPS

Line 1422: mfg_lookups mfl

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