24: l_distribution_source_book,
25: l_fiscal_year_name,
26: l_currency_code
27: FROM FA_BOOK_CONTROLS_MRC_V bc,
28: GL_SETS_OF_BOOKS sob
29: WHERE bc.book_type_code = P_BOOK
30: AND sob.set_of_books_id = bc.set_of_books_id;
31: ELSE
32: SELECT bc.book_type_code,
41: l_distribution_source_book,
42: l_fiscal_year_name,
43: l_currency_code
44: FROM FA_BOOK_CONTROLS bc,
45: GL_SETS_OF_BOOKS sob
46: WHERE bc.book_type_code = P_BOOK
47: AND sob.set_of_books_id = bc.set_of_books_id;
48: END IF;
49: Book_Class := l_book_class;
189: THEN
190: BEGIN
191: select mrc_sob_type_code, currency_code
192: into p_mrcsobtype, lp_currency_code
193: from gl_sets_of_books
194: where set_of_books_id = p_ca_set_of_books_id;
195: EXCEPTION
196: WHEN OTHERS THEN
197: p_mrcsobtype := 'P';