APPS.EAM_PMDEF_PUB dependencies on MFG_LOOKUPS

Line 1608: l_lookup_type mfg_lookups.lookup_type%type;

1604: l_asset_activity_id number;
1605: l_last_service_start_date date;
1606: l_last_service_end_date date;
1607: l_pm_schedule_id number;
1608: l_lookup_type mfg_lookups.lookup_type%type;
1609: l_status_id number;
1610:
1611:
1612: begin

Line 1675: from mfg_lookups

1671:
1672: /* Bug # 3840702 : Need to replace literals by bind variable */
1673: l_lookup_type := 'EAM_PM_TYPE';
1674: select count(*) into l_count
1675: from mfg_lookups
1676: where lookup_type = l_lookup_type
1677: and lookup_code=p_pm_schedule_rec.type_code;
1678:
1679: if (l_count=0) then

Line 1686: from mfg_lookups

1682: end if;
1683:
1684: l_lookup_type := 'EAM_PM_SCHEDULING_METHOD';
1685: select count(*) into l_count
1686: from mfg_lookups
1687: where lookup_type = l_lookup_type
1688: and lookup_code=p_pm_schedule_rec.scheduling_method_code;
1689:
1690: if (l_count=0) then