DBA Data[Home] [Help]

APPS.FA_WHATIF_DEPRN2_PKG dependencies on FA_BOOK_CONTROLS

Line 64: from fa_book_controls where book_type_code = X_book)

60: where g.application_id = 101
61: and g.id_flex_code = 'GL#'
62: and g.id_flex_num = (
63: select accounting_flex_structure
64: from fa_book_controls where book_type_code = X_book)
65: and g.enabled_flag = 'Y'
66: and c.application_id = g.application_id
67: and c.table_id = (select table_id
68: from fnd_tables

Line 183: select amortize_flag into h_check from fa_book_controls

179: -- MAKE SURE AMORTIZED ADJ ARE ALLOWED FOR THIS BOOK
180:
181: if (X_exp_amt = 'AMORTIZED') then
182:
183: select amortize_flag into h_check from fa_book_controls
184: where book_type_code = X_book;
185:
186: if h_check = 'NO' then
187: fnd_message.set_name('OFA','FA_BOOK_AMORTIZED_NOT_ALLOW');

Line 211: from fa_book_controls where book_type_code = X_book;

207:
208: h_mesg_name := 'FA_REC_SQL_ACCT_FLEX';
209:
210: select accounting_flex_structure into h_acct_struct
211: from fa_book_controls where book_type_code = X_book;
212:
213: h_mesg_name := 'FA_DYN_CURRENCY';
214:
215:

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

213: h_mesg_name := 'FA_DYN_CURRENCY';
214:
215:
216: select cur.precision into h_precision
217: from fa_book_controls bc, gl_sets_of_books sob, fnd_currencies cur
218: where bc.book_type_code = X_book
219: --and sob.set_of_books_id = bc.set_of_books_id
220: and sob.set_of_books_id = FARX_C_WD.sob_id -- Enhancement bug 3037321
221: and sob.currency_code = cur.currency_code;