APPS.FA_XLA_EXTRACT_DEPRN_PKG dependencies on FA_DEPRN_PERIODS

Line 85: fa_deprn_periods dp,

81: ctlgd.event_date ,
82: decode(bc.GL_POSTING_ALLOWED_FLAG ,
83: 'YES', 'Y','N')
84: FROM xla_events_gt ctlgd,
85: fa_deprn_periods dp,
86: fa_book_controls bc
87: WHERE ctlgd.entity_code = 'DEPRECIATION'
88: AND ctlgd.event_type_code = 'DEPRECIATION'
89: AND dp.book_type_code = ctlgd.source_id_char_1

Line 127: fa_deprn_periods dp,

123: ctlgd.event_date ,
124: decode(mcbc.GL_POSTING_ALLOWED_FLAG ,
125: 'YES', 'Y','N')
126: FROM xla_events_gt ctlgd,
127: fa_deprn_periods dp,
128: fa_book_controls bc ,
129: fa_mc_book_controls mcbc ,
130: gl_ledgers le
131: WHERE ctlgd.entity_code = 'DEPRECIATION'

Line 199: fa_deprn_periods dp,

195: 'N'),
196: ctlgd.event_date
197: FROM xla_events_gt ctlgd,
198: fa_book_controls bc,
199: fa_deprn_periods dp,
200: fa_deprn_events ds
201: WHERE ctlgd.entity_code = 'DEPRECIATION'
202: AND ctlgd.event_type_code = 'ROLLBACK_DEPRECIATION'
203: AND ds.asset_id = ctlgd.source_id_int_1

Line 232: fa_deprn_periods dp,

228: 'N'),
229: ctlgd.event_date
230: FROM xla_events_gt ctlgd,
231: fa_mc_book_controls bc,
232: fa_deprn_periods dp,
233: fa_mc_deprn_Summary_h ds
234: WHERE ctlgd.entity_code = 'DEPRECIATION'
235: AND ctlgd.event_type_code = 'ROLLBACK_DEPRECIATION'
236: AND ds.asset_id = ctlgd.source_id_int_1

Line 380: fa_deprn_periods dp

376: fa_asset_history ah,
377: fa_category_books cb,
378: fa_book_controls bc,
379: gl_ledgers le,
380: fa_deprn_periods dp
381: where ctlgd.entity_code = 'DEPRECIATION'
382: AND ctlgd.event_type_code = 'DEPRECIATION'
383: AND dd.asset_id = ctlgd.source_id_int_1
384: AND dd.book_type_code = ctlgd.source_id_char_1

Line 500: fa_deprn_periods dp

496: fa_asset_history ah,
497: fa_category_books cb,
498: fa_mc_book_controls bc,
499: gl_ledgers le,
500: fa_deprn_periods dp
501: where ctlgd.entity_code = 'DEPRECIATION'
502: AND ctlgd.event_type_code = 'DEPRECIATION'
503: AND dd.asset_id = ctlgd.source_id_int_1
504: AND dd.book_type_code = ctlgd.source_id_char_1