DBA Data[Home] [Help]

APPS.FA_DEPRN_EVENTS_PKG dependencies on FA_DEPRN_SUMMARY

Line 31: from fa_deprn_summary

27: p_period_counter number
28: ) IS
29: select rowid,
30: asset_id
31: from fa_deprn_summary
32: where book_type_code = p_book_type_code
33: and period_counter = p_period_counter
34: and event_id is null
35: and (deprn_amount - deprn_adjustment_amount <> 0 or

Line 96: select fa_deprn_summary_s.nextval

92: end if;
93:
94: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);
95:
96: select fa_deprn_summary_s.nextval
97: into l_deprn_run_id
98: from dual;
99:
100: if (g_log_level_rec.statement_level) then

Line 169: UPDATE FA_DEPRN_SUMMARY

165: p_log_level_rec => g_log_level_rec);
166: end if;
167:
168: FORALL l_count in 1..l_asset_id_tbl.count
169: UPDATE FA_DEPRN_SUMMARY
170: SET event_id = l_event_id_tbl(l_count),
171: deprn_run_id = l_deprn_run_id
172: WHERE rowid = l_rowid_tbl(l_count);
173: