APPS.EAM_ACTIVITYASSOCIATION_PVT dependencies on EAM_PM_SCHEDULINGS

Line 1606: SELECT COUNT(1) INTO l_count FROM eam_pm_schedulings eps, eam_pm_activities epa

1602:
1603: --Bug 5137572
1604: Begin
1605: l_date_insert := l_current_date;
1606: SELECT COUNT(1) INTO l_count FROM eam_pm_schedulings eps, eam_pm_activities epa
1607: WHERE epa.activity_association_id = l_asset_activity_row.activity_association_id
1608: AND epa.pm_schedule_id = eps.pm_schedule_id
1609: AND nvl(eps.tmpl_flag, 'N') = 'Y' AND eps.auto_instantiation_flag = 'Y';
1610: if ( l_count = 0 ) then