DBA Data[Home] [Help]

APPS.FA_TERMINAL_GAIN_LOSS_PVT dependencies on FA_BOOK_CONTROLS

Line 33: from fa_book_controls

29: CURSOR c_get_deprn_run_date IS
30: select last_update_date
31: , last_updated_by
32: , last_update_login
33: from fa_book_controls
34: where book_type_code = p_book_type_code;
35:
36: CURSOR c_get_mc_deprn_run_date IS
37: select last_update_date

Line 40: from fa_book_controls_mrc_v

36: CURSOR c_get_mc_deprn_run_date IS
37: select last_update_date
38: , last_updated_by
39: , last_update_login
40: from fa_book_controls_mrc_v
41: where book_type_code = p_book_type_code;
42:
43: -- +++++ Get Current Unit and category_id of Group Asset +++++
44: CURSOR c_get_unit IS

Line 104: -- Get last_update_date from fa_book_controls

100:
101: raise tgl_err;
102: end if;
103:
104: -- Get last_update_date from fa_book_controls
105: -- date effective for this terminal gain loss trx
106: -- will be last_update_date - 1 sec.
107: if (p_mrc_sob_type_code = 'R') then
108: OPEN c_get_mc_deprn_run_date;