APPS.FA_DEPRN_ROLLBACK_PVT dependencies on FA_DEPRN_DETAIL

Line 187: insert into fa_deprn_detail_h_mrc_v

183: and ds.asset_id = p_asset_hdr_rec.asset_id
184: and ds.period_counter = p_period_rec.period_counter
185: and ds.deprn_source_code in ('DEPRN','TRACK');
186:
187: insert into fa_deprn_detail_h_mrc_v
188: (BOOK_TYPE_CODE ,
189: ASSET_ID ,
190: PERIOD_COUNTER ,
191: DISTRIBUTION_ID ,

Line 236: from fa_deprn_detail_mrc_v ds

232: EVENT_ID ,
233: DEPRN_RUN_ID ,
234: P_REVERSAL_EVENT_ID ,
235: P_REVERSAL_DATE
236: from fa_deprn_detail_mrc_v ds
237: where ds.book_type_code = p_asset_hdr_rec.book_type_code
238: and ds.asset_id = p_asset_hdr_rec.asset_id
239: and ds.period_counter = p_period_rec.period_counter
240: and ds.deprn_source_code in ('D','T');

Line 312: insert into fa_deprn_detail_h

308: and ds.asset_id = p_asset_hdr_rec.asset_id
309: and ds.period_counter = p_period_rec.period_counter
310: and ds.deprn_source_code in ('DEPRN','TRACK');
311:
312: insert into fa_deprn_detail_h
313: (BOOK_TYPE_CODE ,
314: ASSET_ID ,
315: PERIOD_COUNTER ,
316: DISTRIBUTION_ID ,

Line 361: from fa_deprn_detail ds

357: EVENT_ID ,
358: DEPRN_RUN_ID ,
359: P_REVERSAL_EVENT_ID ,
360: P_REVERSAL_DATE
361: from fa_deprn_detail ds
362: where ds.book_type_code = p_asset_hdr_rec.book_type_code
363: and ds.asset_id = p_asset_hdr_rec.asset_id
364: and ds.period_counter = p_period_rec.period_counter
365: and ds.deprn_source_code in ('D','T');

Line 584: from fa_deprn_detail_mrc_v dd

580: -- delete from DD
581:
582: if (p_mrc_sob_type_code = 'R') then
583: delete
584: from fa_deprn_detail_mrc_v dd
585: where dd.asset_id = p_asset_hdr_rec.asset_id
586: and dd.book_type_code = p_asset_hdr_rec.book_type_code
587: and dd.period_counter = p_period_rec.period_counter
588: and dd.deprn_source_code in ('D','T');

Line 591: from fa_deprn_detail dd

587: and dd.period_counter = p_period_rec.period_counter
588: and dd.deprn_source_code in ('D','T');
589: else
590: delete
591: from fa_deprn_detail dd
592: where dd.asset_id = p_asset_hdr_rec.asset_id
593: and dd.book_type_code = p_asset_hdr_rec.book_type_code
594: and dd.period_counter = p_period_rec.period_counter
595: and dd.deprn_source_code in ('D','T');