288: -- cursor to get precision.
289: CURSOR get_precision IS
290: SELECT curr.precision
291: FROM fnd_currencies curr, gl_sets_of_books sob,
292: fa_book_controls bc
293: WHERE curr.currency_code = sob.currency_code
294: AND sob.set_of_books_id = bc.set_of_books_id
295: AND bc.book_type_code = mr_rec.book_type_code;
296:
307: WHERE employee_id = mr_rec.employee_id;
308:
309: -- cursor to get accounting flexfield structure
310: CURSOR get_acct_flex_struct IS
311: SELECT accounting_flex_structure FROM fa_book_controls
312: WHERE book_type_code = mr_rec.book_type_code;
313:
314: -- cursor to get gl_code_combinations table id
315: CURSOR get_gl_table_id IS