APPS.EAM_OP_VALIDATE_PVT dependencies on MFG_LOOKUPS

Line 461: from mfg_lookups

457: if (p_eam_op_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
458:
459: select 1
460: into g_dummy
461: from mfg_lookups
462: where lookup_type = 'BOM_COUNT_POINT_TYPE'
463: and lookup_code = p_eam_op_rec.count_point_type;
464:
465: end if;

Line 499: from mfg_lookups

495: if (p_eam_op_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
496:
497: select 1
498: into g_dummy
499: from mfg_lookups
500: where lookup_type = 'SYS_YES_NO'
501: and lookup_code = p_eam_op_rec.backflush_flag;
502:
503: end if;

Line 539: from mfg_lookups

535:
536: if p_eam_op_rec.shutdown_type is not null then
537: select 1
538: into g_dummy
539: from mfg_lookups
540: where lookup_type = g_shutdown_type
541: and lookup_code = p_eam_op_rec.shutdown_type
542: and enabled_flag = 'Y';
543: end if;