APPS.FA_DEPRN_ROLLBACK_PVT dependencies on FA_DEPRN_DETAIL

Line 395: insert into fa_deprn_detail_h

391: and ds.asset_id = p_asset_hdr_rec.asset_id
392: and ds.period_counter = p_period_rec.period_counter
393: and ds.deprn_source_code in ('DEPRN','TRACK');
394:
395: insert into fa_deprn_detail_h
396: (BOOK_TYPE_CODE ,
397: ASSET_ID ,
398: PERIOD_COUNTER ,
399: DISTRIBUTION_ID ,

Line 454: from fa_deprn_detail ds

450: EVENT_ID ,
451: DEPRN_RUN_ID ,
452: P_REVERSAL_EVENT_ID ,
453: P_REVERSAL_DATE
454: from fa_deprn_detail ds
455: where ds.book_type_code = p_asset_hdr_rec.book_type_code
456: and ds.asset_id = p_asset_hdr_rec.asset_id
457: and ds.period_counter = p_period_rec.period_counter
458: and ds.deprn_source_code in ('D','T');

Line 692: from fa_deprn_detail dd

688: and dd.deprn_source_code in ('D','T')
689: and dd.set_of_books_id = p_asset_hdr_rec.set_of_books_id ;
690: else
691: delete
692: from fa_deprn_detail dd
693: where dd.asset_id = p_asset_hdr_rec.asset_id
694: and dd.book_type_code = p_asset_hdr_rec.book_type_code
695: and dd.period_counter = p_period_rec.period_counter
696: and dd.deprn_source_code in ('D','T');