DBA Data[Home] [Help]

APPS.JA_CN_FA_BI_EXPORT_PKG dependencies on FA_ADDITIONS_V

Line 70: ,fa_additions_v fav

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
73: AND fbcs.book_class IN ('CORPORATE', 'TAX')
74: AND fbcs.gl_posting_allowed_flag = 'YES'

Line 118: ,fa_additions_v fav

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
121: AND fbcs.book_class IN ('CORPORATE', 'TAX')
122: AND fbcs.gl_posting_allowed_flag = 'YES'

Line 166: ,fa_additions_v fav

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
169: AND fbcs.book_class IN ('CORPORATE', 'TAX')
170: AND fbcs.gl_posting_allowed_flag = 'YES'