520: BEGIN
521: select event_id, deprn_run_id
522: into l_event_id,
523: l_deprn_run_id
524: from fa_deprn_events_v de
525: where de.book_type_code = p_book_type_code
526: and de.asset_id = p_asset_id
527: and de.period_counter = l_period_rec.period_counter
528: and de.reversal_event_id is null;