APPS.EAM_PMDEF_PUB dependencies on EAM_PM_SET_NAMES

Line 587: from eam_pm_schedulings eps, mtl_eam_asset_activities meaa, eam_pm_set_names epsn

583: -- of l_activity_assoc_id, that have auto_instantiation_flag as "Y"
584:
585: cursor pm_template_csr_old IS
586: select pm_schedule_id
587: from eam_pm_schedulings eps, mtl_eam_asset_activities meaa, eam_pm_set_names epsn
588: where eps.activity_association_id=meaa.source_tmpl_id
589: and meaa.activity_association_id=l_activity_assoc_id
590: and eps.tmpl_flag='Y'
591: and eps.auto_instantiation_flag='Y'

Line 597: from eam_pm_schedulings eps, eam_pm_activities epa,mtl_eam_asset_activities meaa, eam_pm_set_names epsn

593: and (epsn.end_date is null or (epsn.end_date > sysdate and epsn.end_date > nvl(eps.to_effective_date, sysdate)));
594:
595: cursor pm_template_csr IS
596: select distinct eps.pm_schedule_id
597: from eam_pm_schedulings eps, eam_pm_activities epa,mtl_eam_asset_activities meaa, eam_pm_set_names epsn
598: where eps.pm_schedule_id=epa.pm_schedule_id
599: and epa.activity_association_id=meaa.source_tmpl_id
600: and meaa.activity_association_id=l_activity_assoc_id
601: and eps.tmpl_flag='Y'

Line 1719: from eam_pm_set_names

1715: -- header validation : set name effective end date > sysdate
1716: -- header validation: pm start and end date is within effective dates of set name
1717:
1718: select count(*) into l_count
1719: from eam_pm_set_names
1720: where set_name_id = p_pm_schedule_rec.set_name_id;
1721:
1722: if (l_count=0) then
1723: x_reason_failed:='EAM_PM_HD_INVALID_SET_NAME';