DBA Data[Home] [Help]

APPS.FA_XLA_EXTRACT_DEPRN_PKG dependencies on FA_BOOK_CONTROLS

Line 82: fa_book_controls bc

78: decode(bc.GL_POSTING_ALLOWED_FLAG ,
79: 'YES', 'Y','N')
80: FROM xla_events_gt ctlgd,
81: fa_deprn_periods dp,
82: fa_book_controls bc
83: WHERE ctlgd.entity_code = 'DEPRECIATION'
84: AND ctlgd.event_type_code = 'DEPRECIATION'
85: AND dp.book_type_code = ctlgd.source_id_char_1
86: AND dp.period_counter = ctlgd.source_id_int_2

Line 143: fa_book_controls bc,

139: 'YES', 'Y',
140: 'N'),
141: dp.CALENDAR_PERIOD_CLOSE_DATE
142: FROM xla_events_gt ctlgd,
143: fa_book_controls bc,
144: fa_deprn_periods dp,
145: fa_deprn_events ds
146: WHERE ctlgd.entity_code = 'DEPRECIATION'
147: AND ctlgd.event_type_code = 'ROLLBACK_DEPRECIATION'

Line 269: fa_book_controls bc,

265: fa_distribution_history dh,
266: fa_additions_b ad,
267: fa_asset_history ah,
268: fa_category_books cb,
269: fa_book_controls bc,
270: gl_ledgers le
271: where ctlgd.entity_code = 'DEPRECIATION'
272: AND ctlgd.event_type_code = 'DEPRECIATION'
273: AND dd.asset_id = ctlgd.source_id_int_1