APPS.IGI_IAC_REVAL_UTILITIES dependencies on FA_BOOK_CONTROLS

Line 102: from fa_calendar_types ct , fa_book_controls bc , fa_books bk

98: begin
99: l_path_name := g_path||'last_period_counter';
100: select ct.calendar_type , ct.number_per_fiscal_year , bk.life_in_months
101: into l_calendar_type , l_number_per_fiscal_year , l_life_in_months
102: from fa_calendar_types ct , fa_book_controls bc , fa_books bk
103: where ct.calendar_type = bc.deprn_calendar
104: and bk.book_type_code = p_book_type_code
105: and bk.date_ineffective is null
106: and bk.asset_id = p_asset_id

Line 134: FROM fa_book_controls

130:
131: /* Bug 2763328 sekhar */
132: CURSOR c_get_deprn_calendar (p_book_type_code fa_books.book_type_code%type) IS
133: SELECT deprn_calendar
134: FROM fa_book_controls
135: WHERE book_type_code like p_book_type_code;
136:
137: /* Bug 2763328 sekhar */
138: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS

Line 674: FROM fa_calendar_types ct, fa_book_controls bc

670: AND fds.deprn_source_code = 'DEPRN';
671:
672: CURSOR c_get_periods_in_year IS
673: SELECT ct.number_per_fiscal_year
674: FROM fa_calendar_types ct, fa_book_controls bc
675: WHERE ct.calendar_type = bc.deprn_calendar
676: AND bc.book_type_code = fp_book_type_code;
677:
678: l_prorate_dists_idx binary_integer ;

Line 892: FROM fa_calendar_types ct, fa_book_controls bc

888: AND fds.deprn_source_code = 'DEPRN';
889:
890: CURSOR c_get_periods_in_year IS
891: SELECT ct.number_per_fiscal_year
892: FROM fa_calendar_types ct, fa_book_controls bc
893: WHERE ct.calendar_type = bc.deprn_calendar
894: AND bc.book_type_code = fp_book_type_code;
895:
896: l_prorate_dists_idx binary_integer ;

Line 1205: FA_BOOK_CONTROLS bc

1201: nvl(DEPRN_EXPENSE_ACCOUNT_CCID, -1),
1202: nvl(DEPRN_RESERVE_ACCOUNT_CCID, -1),
1203: bc.accounting_flex_structure
1204: FROM FA_DISTRIBUTION_ACCOUNTS da,
1205: FA_BOOK_CONTROLS bc
1206: WHERE bc.book_type_code = p_book_type_code
1207: AND da.book_type_code = bc.book_type_code
1208: AND da.distribution_id = c_distribution_id;
1209:

Line 1369: FROM fa_book_controls

1365: -- get the flex_num and default CCID
1366:
1367: SELECT accounting_flex_structure, flexbuilder_defaults_ccid
1368: into l_flex_num, l_default_ccid
1369: FROM fa_book_controls
1370: WHERE book_type_code = p_book_type_code ;
1371:
1372: IF (l_adj_type(l_loop_count) = 'COST') THEN
1373: -- get the COST