DBA Data[Home] [Help]

APPS.EAM_SUB_RESOURCE_VALIDATE_PVT dependencies on MFG_LOOKUPS

Line 365: from mfg_lookups

361: if (p_eam_sub_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
362:
363: select 1
364: into g_dummy
365: from mfg_lookups
366: where lookup_type = 'CST_BASIS'
367: and lookup_code in (1,2)
368: and lookup_code = p_eam_sub_res_rec.basis_type;
369:

Line 450: from mfg_lookups

446: if (p_eam_sub_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
447:
448: select 1
449: into g_dummy
450: from mfg_lookups
451: where lookup_type = g_autocharge_type
452: and lookup_code in (2,3)
453: and lookup_code = p_eam_sub_res_rec.autocharge_type;
454:

Line 490: from mfg_lookups

486: if (p_eam_sub_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
487:
488: select 1
489: into g_dummy
490: from mfg_lookups
491: where lookup_type = 'BOM_RESOURCE_SCHEDULE_TYPE'
492: and lookup_code = p_eam_sub_res_rec.scheduled_flag;
493:
494: end if;