APPS.EAM_REBUILDS_PVT dependencies on MTL_EAM_ASSET_ACTIVITIES

Line 208: from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd, csi_item_instances cii

204: end if;
205: if (l_serial_control_code > 1) then
206:
207: select meaa.activity_association_id into l_dummy_num
208: from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd, csi_item_instances cii
209: where ( meaa.end_date_active is null or meaa.end_date_active > sysdate)
210: and (meaa.start_date_active is null or meaa.start_date_active < sysdate)
211: and meaa.asset_activity_id = p_rebuild_activity_id
212: and nvl(meaa.tmpl_flag, 'N') = 'N'

Line 222: from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd

218: and meaa.maintenance_object_type = 3
219: and meaa.maintenance_object_id = cii.instance_id;
220: else
221: select meaa.activity_association_id into l_dummy_num
222: from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd
223: where ( meaa.end_date_active is null or meaa.end_date_active > sysdate)
224: and (meaa.start_date_active is null or meaa.start_date_active < sysdate)
225: and meaa.asset_activity_id = p_rebuild_activity_id
226: and meaa.maintenance_object_type = 2