415: THEN
416: begin
417: SELECT description
418: INTO l_activity_description
419: FROM MTL_SYSTEM_ITEMS_KFV MSI, MTL_PARAMETERS MP
420: WHERE MSI.inventory_item_id = p_eam_wo_rec.asset_activity_id
421: AND MSI.organization_id = MP.ORGANIZATION_ID
422: AND MP.MAINT_ORGANIZATION_ID = p_eam_wo_rec.organization_id
423: AND rownum = 1;