APPS.EAM_ACTIVITYASSOCIATION_PVT dependencies on EAM_PM_SCHEDULINGS

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

1690:
1691: --Bug 5137572
1692: Begin
1693: l_date_insert := l_current_date;
1694: SELECT COUNT(1) INTO l_count FROM eam_pm_schedulings eps, eam_pm_activities epa
1695: WHERE epa.activity_association_id = l_asset_activity_row.activity_association_id
1696: AND epa.pm_schedule_id = eps.pm_schedule_id
1697: AND nvl(eps.tmpl_flag, 'N') = 'Y' AND eps.auto_instantiation_flag = 'Y';
1698: if ( l_count = 0 ) then