DBA Data[Home] [Help]

APPS.FA_MASSADD_CREATE_PKG dependencies on FA_CATEGORY_BOOKS

Line 180: from fa_category_books

176: 'CAPITALIZED')
177: from (select asset_clearing_acct clearing_acct
178: ,book_type_code
179: , 2 acct_type
180: from fa_category_books
181: where book_type_code = p_book_type_code
182: UNION
183: select cip_clearing_acct , book_type_code, 1
184: from fa_category_books

Line 184: from fa_category_books

180: from fa_category_books
181: where book_type_code = p_book_type_code
182: UNION
183: select cip_clearing_acct , book_type_code, 1
184: from fa_category_books
185: where cip_clearing_acct is not null
186: and book_type_code = p_book_type_code)
187: group by clearing_acct, book_type_code;
188:

Line 203: from fa_category_books cb,

199: 'CAPITALIZED')
200: from (select asset_clearing_acct clearing_acct
201: , cb.book_type_code
202: , 2 acct_type
203: from fa_category_books cb,
204: fa_book_controls bc
205: where cb.book_type_code = bc.book_type_code
206: and bc.book_class = 'CORPORATE'
207: and bc.set_of_books_id = p_ledger_id

Line 210: from fa_category_books cb,

206: and bc.book_class = 'CORPORATE'
207: and bc.set_of_books_id = p_ledger_id
208: UNION
209: select cip_clearing_acct , cb.book_type_code, 1
210: from fa_category_books cb,
211: fa_book_controls bc
212: where cip_clearing_acct is not null
213: and cb.book_type_code = bc.book_type_code
214: and bc.book_class = 'CORPORATE'