DBA Data[Home] [Help]

APPS.EAM_ASSET_NUM_IMPORT_PVT dependencies on MTL_PARAMETERS

Line 354: SET organization_code= (select organization_code from mtl_parameters

350: END IF;
351:
352:
353: UPDATE mtl_eam_asset_num_interface meani
354: SET organization_code= (select organization_code from mtl_parameters
355: where organization_id = meani.current_organization_id
356: and maint_organization_id is NOT NULL)
357: WHERE batch_id = p_batch_id
358: AND current_organization_id is not null

Line 362: SET current_organization_id= (select organization_id from mtl_parameters

358: AND current_organization_id is not null
359: AND process_flag = 'P';
360:
361: UPDATE mtl_eam_asset_num_interface meani
362: SET current_organization_id= (select organization_id from mtl_parameters
363: where organization_code = meani.organization_code
364: and maint_organization_id is NOT NULL)
365: WHERE batch_id = p_batch_id
366: AND current_organization_id is null