The following lines contain the word 'select', 'insert', 'update' or 'delete':
select book_type_code
from fa_asset_hierarchy_purpose
where asset_hierarchy_purpose_id =
( select asset_hierarchy_purpose_id
from fa_asset_hierarchy
where asset_hierarchy_id = p_parent_hierarchy_id
and level_number = 1);
select asset_hierarchy_purpose_id
from fa_asset_hierarchy_purpose
where book_type_code = p_asset_hdr_rec.book_type_code
and purpose_type = 'INHERITANCE';
select asset_number
into l_asset_number
from fa_additions
where asset_id = p_asset_hdr_rec.asset_id;
select distribution_line_percentage unit_percentage,
code_combination_id deprn_expense_ccid,
location_id,
assigned_to
from fa_hierarchy_distributions
where dist_set_id = p_hr_dist_set_id;
px_asset_dist_tbl.delete;
SELECT cua_inheritance_flag
INTO l_inherit_flag
FROM fa_system_controls;
select depreciation_start_date
into l_parent_deprn_start_date
from fa_asset_hierarchy
where asset_hierarchy_id = p_asset_hr_rec.parent_hierarchy_id;
fa_cua_derive_asset_attr_pkg.insert_mass_update_batch_hdrs(
x_event_code => p_asset_hr_opt_rec.event_code
, x_book_type_code => p_asset_hdr_rec.book_type_code
, x_status_code => p_asset_hr_opt_rec.status_code
, x_source_entity_name => p_asset_hr_opt_rec.source_entity_name
, x_source_entity_key_value => p_asset_hr_opt_rec.source_entity_value
, x_source_attribute_name => p_asset_hr_opt_rec.source_attribute_name
, x_source_attribute_old_id => p_asset_hr_opt_rec.source_attribute_old_id
, x_source_attribute_new_id => p_asset_hr_opt_rec.source_attribute_new_id
, x_description => p_asset_hr_opt_rec.description
, x_amortize_flag => p_asset_hr_opt_rec.amortize_flag
, x_amortization_date => p_asset_hr_opt_rec.amortization_start_date
, x_rejection_reason_code => p_asset_hr_opt_rec.rejection_reason_code
, x_concurrent_request_id => p_asset_hr_opt_rec.concurrent_request_id
, x_created_by => p_trans_rec.who_info.created_by
, x_creation_date => p_trans_rec.who_info.creation_date
, x_last_updated_by => p_trans_rec.who_info.last_updated_by
, x_last_update_date => p_trans_rec.who_info.last_update_date
, x_last_update_login => p_trans_rec.who_info.last_update_login
, x_batch_number => l_batch_num
, x_batch_id => l_batch_id
, x_transaction_name => p_trans_rec.transaction_name
, x_attribute_category => p_trans_rec.desc_flex.attribute_category_code
, x_attribute1 => p_trans_rec.desc_flex.attribute1
, x_attribute2 => p_trans_rec.desc_flex.attribute2
, x_attribute3 => p_trans_rec.desc_flex.attribute3
, x_attribute4 => p_trans_rec.desc_flex.attribute4
, x_attribute5 => p_trans_rec.desc_flex.attribute5
, x_attribute6 => p_trans_rec.desc_flex.attribute6
, x_attribute7 => p_trans_rec.desc_flex.attribute7
, x_attribute8 => p_trans_rec.desc_flex.attribute8
, x_attribute9 => p_trans_rec.desc_flex.attribute9
, x_attribute10 => p_trans_rec.desc_flex.attribute10
, x_attribute11 => p_trans_rec.desc_flex.attribute11
, x_attribute12 => p_trans_rec.desc_flex.attribute12
, x_attribute13 => p_trans_rec.desc_flex.attribute13
, x_attribute14 => p_trans_rec.desc_flex.attribute14
, x_attribute15 => p_trans_rec.desc_flex.attribute15
, x_err_code => l_err_code
, x_err_stage => l_err_stage
, x_err_stack => l_err_stack , p_log_level_rec => p_log_level_rec);
Update fa_mass_update_batch_headers
set status_code = 'IP'
, concurrent_request_id = l_request_num
where batch_id = l_batch_id;