DBA Data[Home] [Help]

APPS.FARX_AD dependencies on FA_BOOK_CONTROLS

Line 182: from fa_book_controls

178: h_mesg_name := 'FA_REC_SQL_ACCT_FLEX';
179:
180: select nvl(distribution_source_book, book_type_code), accounting_flex_structure
181: into h_dist_source_book, h_acct_flex_struct
182: from fa_book_controls
183: where book_type_code = h_book;
184:
185: h_mesg_name := 'FA_FA_LOOKUP_IN_SYSTEM_CTLS';
186:

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

204: into h_chart_of_accounts_id,
205: h_set_of_books_id,
206: h_currency_code,
207: h_organization_name
208: from fa_book_controls bc, gl_sets_of_books sob, fnd_currencies cur
209: WHERE bc.book_type_code = h_book
210: AND sob.set_of_books_id = bc.set_of_books_id
211: AND sob.currency_code = cur.currency_code; -- Added set_of_books_id and currency_code to display those on report
212:

Line 1795: from fa_book_controls

1791: h_mesg_name := 'FA_REC_SQL_ACCT_FLEX';
1792:
1793: select nvl(distribution_source_book, book_type_code), accounting_flex_structure
1794: into h_dist_source_book, h_acct_flex_struct
1795: from fa_book_controls
1796: where book_type_code = h_book;
1797:
1798: h_mesg_name := 'FA_FA_LOOKUP_IN_SYSTEM_CTLS';
1799:

Line 2317: from fa_book_controls

2313: h_mesg_name := 'FA_REC_SQL_ACCT_FLEX';
2314:
2315: select nvl(distribution_source_book, book_type_code), accounting_flex_structure
2316: into h_dist_source_book, h_acct_flex_struct
2317: from fa_book_controls
2318: where book_type_code = h_book;
2319:
2320: h_mesg_name := 'FA_FA_LOOKUP_IN_SYSTEM_CTLS';
2321: