APPS.EAM_PMDEF_PUB dependencies on EAM_PM_SET_NAMES

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

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

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

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

Line 1634: from eam_pm_set_names

1630: -- header validation : set name effective end date > sysdate
1631: -- header validation: pm start and end date is within effective dates of set name
1632:
1633: select count(*) into l_count
1634: from eam_pm_set_names
1635: where set_name_id = p_pm_schedule_rec.set_name_id;
1636:
1637: if (l_count=0) then
1638: x_reason_failed:='EAM_PM_HD_INVALID_SET_NAME';