DBA Data[Home] [Help]

APPS.FARX_AJ dependencies on FA_BOOK_CONTROLS

Line 228: from fa_book_controls

224:
225: h_mesg_name := 'FA_AMT_SEL_PERIODS';
226: /* fix for bug no.3803578. Added the following query to get the distribution_source_book*/
227: select distribution_source_book into h_distribution_source_book
228: from fa_book_controls
229: where book_type_code=h_book;
230:
231: select period_open_date
232: into h_period1_pod

Line 253: from fa_book_controls

249: h_mesg_name := 'FA_REC_SQL_ACCT_FLEX';
250:
251: select accounting_flex_structure
252: into h_acct_struct
253: from fa_book_controls
254: where book_type_code = h_book;
255:
256: h_mesg_name := 'FA_FA_LOOKUP_IN_SYSTEM_CTLS';
257:

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

268: CC_SEGNUM => h_cc_seg,
269: CALLING_FN => 'COST_ADJUST');
270:
271: select cur.precision into h_precision
272: from fa_book_controls bc, gl_sets_of_books sob, fnd_currencies cur
273: where bc.book_type_code = h_book
274: and sob.set_of_books_id = bc.set_of_books_id
275: and sob.currency_code = cur.currency_code;
276:

Line 495: fa_book_controls BC

491: gl_code_combinations glcc_ar ,
492: XLA_AE_HEADERS HEADERS ,
493: XLA_AE_LINES LINES ,
494: XLA_DISTRIBUTION_LINKS LINKS ,
495: fa_book_controls BC
496: WHERE bc.book_type_code = h_book
497: AND th.book_type_code = bc.book_type_code AND
498: th.date_effective BETWEEN h_period1_pod AND nvl(h_period1_pcd,sysdate)
499: AND adj1.book_type_code = th.book_type_code AND

Line 566: from fa_book_controls

562: h_mesg_name := 'FA_REC_SQL_ACCT_FLEX';
563:
564: select accounting_flex_structure
565: into h_acct_struct
566: from fa_book_controls
567: where book_type_code = h_book;
568:
569: h_mesg_name := 'FA_RX_SEGNUMS';
570: