24: l_distribution_source_book,
25: l_currency_code,
26: l_precision
27: FROM FA_BOOK_CONTROLS_MRC_V bc,
28: GL_SETS_OF_BOOKS sob,
29: FND_CURRENCIES cur
30: WHERE bc.book_type_code = P_BOOK
31: AND sob.set_of_books_id = bc.set_of_books_id
32: AND sob.currency_code = cur.currency_code;
43: l_distribution_source_book,
44: l_currency_code,
45: l_precision
46: FROM FA_BOOK_CONTROLS bc,
47: GL_SETS_OF_BOOKS sob,
48: FND_CURRENCIES cur
49: WHERE bc.book_type_code = P_BOOK
50: AND sob.set_of_books_id = bc.set_of_books_id
51: AND sob.currency_code = cur.currency_code;
199: THEN
200: BEGIN
201: select mrc_sob_type_code, currency_code
202: into p_mrcsobtype, lp_currency_code
203: from gl_sets_of_books
204: where set_of_books_id = p_ca_set_of_books_id;
205: EXCEPTION
206: WHEN OTHERS THEN
207: p_mrcsobtype := 'P';