APPS.EAM_PROCESS_FAILURE_ENTRY_PUB dependencies on EAM_ASSET_FAILURES

Line 332: FROM eam_asset_failures

328: BEGIN
329: IF l_eam_failure_entry_record.source_id IS NOT NULL THEN
330: SELECT failure_id
331: INTO l_eam_failure_entry_record.failure_id
332: FROM eam_asset_failures
333: WHERE source_id = l_eam_failure_entry_record.source_id
334: AND source_type = 1;
335: ELSE
336: SELECT failure_id

Line 338: FROM eam_asset_failures

334: AND source_type = 1;
335: ELSE
336: SELECT failure_id
337: INTO l_eam_failure_entry_record.failure_id
338: FROM eam_asset_failures
339: WHERE source_id = ( SELECT wip_entity_id
340: FROM WIP_ENTITIES
341: WHERE WIP_ENTITY_NAME = l_eam_failure_entry_record.source_name
342: AND organization_id = l_eam_failure_entry_record.maint_organization_id

Line 366: FROM eam_asset_failures

362:
363: BEGIN
364: SELECT object_type , object_id , source_id , source_type , failure_date , maint_organization_id , current_organization_id , area_id
365: INTO l_object_type, l_object_id , l_source_id, l_source_type, l_failure_date, l_maint_organization_id, l_current_organization_id, l_area_id
366: FROM eam_asset_failures
367: WHERE failure_id = l_eam_failure_entry_record.failure_id;
368: l_eam_failure_entry_record.source_id := l_source_id;
369: EXCEPTION
370: WHEN NO_DATA_FOUND THEN