The following lines contain the word 'select', 'insert', 'update' or 'delete':
dist_table.delete;
p_deleted_flag varchar2,
p_inv_transfer_cost number,
p_inv_update_only varchar2,
p_inv_new_cost number,
p_depreciate_in_group_flag varchar2,
p_attribute1 varchar2 default null,
p_attribute2 varchar2 default null,
p_attribute3 varchar2 default null,
p_attribute4 varchar2 default null,
p_attribute5 varchar2 default null,
p_attribute6 varchar2 default null,
p_attribute7 varchar2 default null,
p_attribute8 varchar2 default null,
p_attribute9 varchar2 default null,
p_attribute10 varchar2 default null,
p_attribute11 varchar2 default null,
p_attribute12 varchar2 default null,
p_attribute13 varchar2 default null,
p_attribute14 varchar2 default null,
p_attribute15 varchar2 default null,
p_attribute_cat_code varchar2 default null,
p_invoice_distribution_id number default null,
p_invoice_line_number number default null,
p_po_distribution_id number default null,
p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
IS
BEGIN
if (g_inv_count=0) then /* initialize inv_line_tbl */
inv_table.delete;
inv_table(g_inv_count).deleted_flag
:= p_deleted_flag;
inv_table(g_inv_count).inv_update_only
:= p_inv_update_only;
dist_table.delete;
inv_table.delete;
SELECT bc.book_type_code
FROM fa_category_books cb, fa_book_controls bc
WHERE p_corp_book =
decode(bc.book_class, 'CORPORATE', bc.book_type_code,
'TAX', bc.distribution_source_book, '')
AND bc.book_type_code = cb.book_type_code
AND cb.category_id = p_category_id
AND nvl(bc.date_ineffective, sysdate + 1) > sysdate;
SELECT h_book, cbd.start_dpis, cbd.end_dpis,
cbd.prorate_convention_code, cbd.deprn_method,
cbd.life_in_months,cbd.basic_rate,cbd.adjusted_rate,
cbd.production_capacity, cbd.unit_of_measure,
cbd.bonus_rule, NULL, cbd.ceiling_name,
cbd.depreciate_flag, cbd.allowed_deprn_limit,
cbd.special_deprn_limit_amount,cbd.percent_salvage_value
FROM FA_CATEGORY_BOOK_DEFAULTS cbd
WHERE cbd.book_type_code = h_book
AND cbd.category_id = p_category_id;
deprn_table.delete;