DBA Data[Home] [Help]

APPS.JA_CN_FA_BI_EXPORT_PKG dependencies on FA_BOOK_CONTROLS_SEC

Line 68: FROM fa_book_controls_sec fbcs

64:
65: -- to get the fixed asset account
66: CURSOR fixed_asset_account_cur IS
67: SELECT DISTINCT fcb.asset_cost_acct
68: FROM fa_book_controls_sec fbcs
69: ,fa_category_books fcb
70: ,fa_additions_v fav
71: WHERE fbcs.book_type_code = fcb.book_type_code
72: AND fbcs.set_of_books_id = pn_ledger_id

Line 116: FROM fa_book_controls_sec fbcs

112:
113: -- to get the accumulated impairment account
114: CURSOR impairment_account_cur IS
115: SELECT DISTINCT fcb.impair_reserve_acct
116: FROM fa_book_controls_sec fbcs
117: ,fa_category_books fcb
118: ,fa_additions_v fav
119: WHERE fbcs.book_type_code = fcb.book_type_code
120: AND fbcs.set_of_books_id = pn_ledger_id

Line 164: FROM fa_book_controls_sec fbcs

160:
161: -- to get the accumulated depreciation account
162: CURSOR depreciation_account_cur IS
163: SELECT DISTINCT fcb.deprn_reserve_acct
164: FROM fa_book_controls_sec fbcs
165: ,fa_category_books fcb
166: ,fa_additions_v fav
167: WHERE fbcs.book_type_code = fcb.book_type_code
168: AND fbcs.set_of_books_id = pn_ledger_id