The following lines contain the word 'select', 'insert', 'update' or 'delete':
select bc.book_type_code
from fa_books bk, fa_book_controls bc
where bc.book_class = 'CORPORATE'
and bk.asset_id = X_Asset_Id
and bk.book_type_code = bc.book_type_code
and bk.date_ineffective is null;
select asset_hierarchy_purpose_id
,name
from fa_asset_hierarchy_purpose
where book_type_code = v_corp_book
and purpose_type = 'INHERITANCE';
select parent_hierarchy_id
from fa_asset_hierarchy
where asset_id = x_asset_id
and asset_hierarchy_purpose_id = x_asset_purpose_id;
select name
from fa_asset_hierarchy
where asset_hierarchy_id = x_parent_hierarchy_id;
select category_id
from fa_categories_b_kfv
where concatenated_segments = x_concatenated_segments;
select concatenated_segments
from fa_categories_b_kfv
where category_id = x_id;
select concatenated_segments
from fa_asset_keywords_kfv
where code_combination_id = x_id;
select concatenated_segments
from fa_locations_kfv
where location_id = x_id;
select concatenated_segments
from gl_code_combinations_kfv
where code_combination_id = x_id;
select name
from fa_employees
where employee_id = x_id;
select employee_number
from fa_employees
where employee_id = x_id;
select lease_number
from fa_leases
where lease_id = x_id;
select lease_id
from fa_leases
where lease_number = x_lease_number;
SELECT override_allowed_flag
FROM FA_HIERARCHY_RULE_DETAILS
WHERE hierarchy_rule_set_id = x_rule_set_id
AND attribute_name = x_attribute_name
AND book_type_code = x_book_type_code;
select count(*) into h_dist_count
from fa_distribution_history
where asset_id = x_Asset_id
and book_type_code = v_book_type_code
and date_ineffective is null;
select count(*) into h_dist_count2
from fa_hierarchy_distributions
where dist_set_id = x_dist_set_id;
select count(*)
into h_dist_count3
from fa_distribution_history fdh ,fa_hierarchy_distributions ihd,fa_additions fa
where fa.asset_id = x_Asset_id
and fdh.asset_id = x_Asset_id
and fdh.date_ineffective is null
and fdh.book_type_code = v_book_type_code
and ihd.dist_set_id = x_dist_set_id
and ihd.code_combination_id||ihd.location_id||ihd.assigned_to||ihd.distribution_line_percentage
= fdh.code_combination_id||fdh.location_id||fdh.assigned_to||round(fdh.units_assigned/fa.current_units,2)*100;
select name
from fa_asset_hierarchy
where asset_hierarchy_id = x_id;
select level_number
from fa_asset_hierarchy
where asset_hierarchy_id = x_id;
select name
from fa_hierarchy_rule_set
where hierarchy_rule_set_id = x_id;
select asset_number
from fa_additions
where asset_id = x_id;
select 1 into dummy
from dual
where exists(select 'X' from fa_mass_update_batch_details
where batch_id = x_batch_id);
select rate_source_rule
from fa_methods a, fa_category_book_defaults b
where b.category_id = x_cat_id
and book_type_code = x_book_type_code
and a.method_code = b.deprn_method
and ( trunc(sysdate) between start_dpis and nvl(end_dpis, trunc(sysdate) ) );
select (cp.end_date)
from fa_calendar_periods cp,
fa_calendar_types ct,
fa_book_controls bc
where bc.book_type_code = X_book_type_code and
bc.date_ineffective is null and
ct.calendar_type = bc.prorate_calendar and
cp.calendar_type = ct.calendar_type and
x_date between cp.start_date and cp.end_date;
select prorate_convention_code
from fa_category_book_defaults
where category_id = x_category_id
and book_type_code = x_book
and ( trunc(sysdate) between start_dpis and nvl(end_dpis, trunc(sysdate)) );
select conv.prorate_date
from fa_conventions conv
where conv.prorate_convention_code = x_prorate_conv
and x_deprn_start_date
between conv.start_date and conv.end_date;
Select fl.meaning, decode(derived_from_entity,
'NODE', FA_CUA_ASSET_WB_APIS_PKG.get_node_name(derived_from_entity_id),
'NODE-P', FA_CUA_ASSET_WB_APIS_PKG.get_node_name(derived_from_entity_id),
'CATEGORY-LED', FA_CUA_ASSET_WB_APIS_PKG.get_category_name(derived_from_entity_id),
'CATEGORY-LIFE', FA_CUA_ASSET_WB_APIS_PKG.get_category_name(derived_from_entity_id),
'LEASE', FA_CUA_ASSET_WB_APIS_PKG.get_lease_number(derived_from_entity_id),
'ASSET', FA_CUA_ASSET_WB_APIS_PKG.get_asset_number(derived_from_entity_id),
null ), derived_from_entity_id
from fa_life_derivation_info, fa_lookups fl
where asset_id =x_asset_id
and book_type_code = x_book_type_code
and transaction_header_id = (select max(transaction_header_id)
from fa_life_derivation_info
where asset_id =x_asset_id
and book_type_code = x_book_type_code
and transaction_header_id = nvl(x_transaction_id,
transaction_header_id))
and (derived_from_entity = fl.lookup_code
AND fl.lookup_type = 'IFA_HR_SRC_ENTITY_NAME');
select level_number
into x_level_number
from fa_asset_hierarchy
where asset_hierarchy_id = x_derived_from_entity_id;
delete from FA_ADJUSTMENTS
where ASSET_ID = x_asset_id
and BOOK_TYPE_CODE = x_book_type_code
and TRANSACTION_HEADER_ID = x_thid
and ADJUSTMENT_TYPE not in ('COST', 'COST CLEARING');