DBA Data[Home] [Help]

APPS.EAM_ASSET_LOG_PVT dependencies on MFG_LOOKUPS

Line 358: SELECT lookup_code INTO l_status FROM mfg_lookups

354:
355: -- VALIDATION 3 Event Id
356: BEGIN
357:
358: SELECT lookup_code INTO l_status FROM mfg_lookups
359: WHERE lookup_type = p_event_type AND
360: lookup_code = p_event_id AND
361: enabled_flag = 'Y' AND
362: p_event_date >= NVL(start_date_active, p_event_date) AND

Line 410: SELECT lookup_code INTO l_status FROM mfg_lookups

406: -- VALIDATION 5 Operable Flag
407:
408: IF p_operable_flag IS NOT NULL THEN
409: BEGIN
410: SELECT lookup_code INTO l_status FROM mfg_lookups
411: WHERE lookup_type = 'SYS_YES_NO' AND
412: enabled_flag = 'Y' AND
413: p_event_date >= NVL(start_date_active, p_event_date) AND
414: p_event_date <= NVL(end_date_active,sysdate) AND

Line 438: SELECT lookup_code INTO l_status FROM mfg_lookups

434: -- VALIDATION 6 Reason Code
435:
436: IF p_reason_code IS NOT NULL THEN
437: BEGIN
438: SELECT lookup_code INTO l_status FROM mfg_lookups
439: WHERE lookup_type = 'EAM_LOG_REASON_CODE' AND
440: enabled_flag = 'Y' AND
441: p_event_date >= NVL(start_date_active,p_event_date) AND
442: p_event_date <= NVL(end_date_active,sysdate) AND