459: ,fa_distribution_history c
460: ,fa_categories_b_kfv d
461: ,fa_books e
462: ,fa_employees f
463: ,gl_code_combinations_kfv g
464: WHERE b.asset_id = c.asset_id
465: AND b.asset_category_id = d.category_id
466: AND b.asset_id = e.asset_id
467: AND c.book_type_code = e.book_type_code
518:
519: BEGIN
520: SELECT concatenated_segments
521: INTO p_asset_header_tbl(tab_row).expense_account_number
522: FROM gl_code_combinations_kfv
523: WHERE code_combination_id = l_code_combination_id;
524: l_code_combination_id:=NULL;
525: EXCEPTION
526: WHEN OTHERS THEN