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 1797: from fa_book_controls

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

Line 2319: from fa_book_controls

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