APPS.FA_CHK_BALSEG_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 32

       SELECT code_combination_id
	 FROM fa_distribution_history FAD
  	WHERE book_type_code=c_book
	  AND asset_id=c_asset_id
	  AND transaction_header_id_out is null;

Line: 39

  select accounting_flex_structure
  into h_structure_num
  from fa_book_controls
  where book_type_code = book;