APPS.EAM_PMDEF_PUB dependencies on MFG_LOOKUPS

Line 1523: l_lookup_type mfg_lookups.lookup_type%type;

1519: l_asset_activity_id number;
1520: l_last_service_start_date date;
1521: l_last_service_end_date date;
1522: l_pm_schedule_id number;
1523: l_lookup_type mfg_lookups.lookup_type%type;
1524: l_status_id number;
1525:
1526:
1527: begin

Line 1590: from mfg_lookups

1586:
1587: /* Bug # 3840702 : Need to replace literals by bind variable */
1588: l_lookup_type := 'EAM_PM_TYPE';
1589: select count(*) into l_count
1590: from mfg_lookups
1591: where lookup_type = l_lookup_type
1592: and lookup_code=p_pm_schedule_rec.type_code;
1593:
1594: if (l_count=0) then

Line 1601: from mfg_lookups

1597: end if;
1598:
1599: l_lookup_type := 'EAM_PM_SCHEDULING_METHOD';
1600: select count(*) into l_count
1601: from mfg_lookups
1602: where lookup_type = l_lookup_type
1603: and lookup_code=p_pm_schedule_rec.scheduling_method_code;
1604:
1605: if (l_count=0) then