DBA Data[Home] [Help]

APPS.FA_WHATIF_DEPRN2_PKG dependencies on FA_BOOK_CONTROLS

Line 85: from fa_book_controls where book_type_code = X_book)

81: where g.application_id = 101
82: and g.id_flex_code = 'GL#'
83: and g.id_flex_num = (
84: select accounting_flex_structure
85: from fa_book_controls where book_type_code = X_book)
86: and g.enabled_flag = 'Y'
87: and c.application_id = g.application_id
88: and c.table_id = (select table_id
89: from fnd_tables

Line 230: select amortize_flag into h_check from fa_book_controls

226: -- MAKE SURE AMORTIZED ADJ ARE ALLOWED FOR THIS BOOK
227:
228: if (X_exp_amt = 'AMORTIZED') then
229:
230: select amortize_flag into h_check from fa_book_controls
231: where book_type_code = X_book;
232:
233: if h_check = 'NO' then
234: fnd_message.set_name('OFA','FA_BOOK_AMORTIZED_NOT_ALLOW');

Line 258: from fa_book_controls where book_type_code = X_book;

254:
255: h_mesg_name := 'FA_REC_SQL_ACCT_FLEX';
256:
257: select accounting_flex_structure into h_acct_struct
258: from fa_book_controls where book_type_code = X_book;
259:
260: h_mesg_name := 'FA_DYN_CURRENCY';
261:
262:

Line 264: from fa_book_controls bc, gl_sets_of_books sob, fnd_currencies cur

260: h_mesg_name := 'FA_DYN_CURRENCY';
261:
262:
263: select cur.precision into h_precision
264: from fa_book_controls bc, gl_sets_of_books sob, fnd_currencies cur
265: where bc.book_type_code = X_book
266: --and sob.set_of_books_id = bc.set_of_books_id
267: and sob.set_of_books_id = FARX_C_WD.sob_id -- Enhancement bug 3037321
268: and sob.currency_code = cur.currency_code;