APPS.EAM_PROCESS_FAILURE_ENTRY_PUB dependencies on EAM_ASSET_FAILURES

Line 329: FROM eam_asset_failures

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

Line 335: FROM eam_asset_failures

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

Line 363: FROM eam_asset_failures

359:
360: BEGIN
361: SELECT object_type , object_id , source_id , source_type , failure_date , maint_organization_id , current_organization_id , area_id
362: 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
363: FROM eam_asset_failures
364: WHERE failure_id = l_eam_failure_entry_record.failure_id;
365: l_eam_failure_entry_record.source_id := l_source_id;
366: EXCEPTION
367: WHEN NO_DATA_FOUND THEN