APPS.FA_SORP_UPG_PKG dependencies on FA_BOOK_CONTROLS

Line 10: select nvl(MC_SOURCE_FLAG,'N') from FA_BOOK_CONTROLS

6: return boolean
7: is
8: v_mc_source_flag varchar2(5);
9: cursor c_mc_cur is
10: select nvl(MC_SOURCE_FLAG,'N') from FA_BOOK_CONTROLS
11: where book_type_code = p_book_type_code;
12: begin
13: open c_mc_cur;
14: fetch c_mc_cur into v_mc_source_flag;

Line 824: fa_book_controls fabkctl

820: IS
821: SELECT fadep.period_counter, facalp.period_name
822: FROM fa_calendar_periods facalp,
823: fa_deprn_periods fadep,
824: fa_book_controls fabkctl
825: WHERE facalp.calendar_type = fabkctl.deprn_calendar
826: AND fabkctl.book_type_code = p_book_type_code
827: AND fadep.book_type_code = fabkctl.book_type_code
828: AND facalp.period_name = fadep.period_name