195: l_calling_fn varchar2(40) := 'FA_AFE_TRANSACTIONS_PKG.process_capitalize';
196:
197: cursor get_distributions(c_book_type_code varchar2, c_asset_id number) is
198: select *
199: from fa_distribution_history
200: where book_type_code = c_book_type_code
201: and asset_id = c_asset_id
202: and date_ineffective is null;
203:
483: l_err_stage varchar2(250);
484: l_calling_fn varchar2(40) := 'FA_AFE_TRANSACTIONS_PKG.process_dry_hole';
485: cursor get_distributions(c_book_type_code varchar2, c_asset_id number) is
486: select *
487: from fa_distribution_history
488: where book_type_code = c_book_type_code
489: and asset_id = c_asset_id
490: and date_ineffective is null;
491: begin