APPS.IGI_IAC_CATCHUP_PKG dependencies on FA_BOOK_CONTROLS

Line 123: FROM fa_book_controls

119: AND asset_id = p_asset_id);
120:
121: CURSOR c_get_deprn_calendar IS
122: SELECT deprn_calendar
123: FROM fa_book_controls
124: WHERE book_type_code like p_book_type_code;
125:
126: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS
127: SELECT number_per_fiscal_year

Line 558: FROM fa_book_controls

554: l_salvage_value_correction number ;
555:
556: CURSOR c_get_deprn_calendar IS
557: SELECT deprn_calendar
558: FROM fa_book_controls
559: WHERE book_type_code = p_asset_balance.book_type_code;
560:
561: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS
562: SELECT number_per_fiscal_year

Line 1447: FROM fa_books b, fa_book_controls c

1443: 0 pys_deprn_reserve,
1444: 0 deprn_amount,
1445: deprn_start_date,
1446: depreciate_flag
1447: FROM fa_books b, fa_book_controls c
1448: WHERE b.book_type_code = p_reval_asset_params(1).book_type_code
1449: AND c.book_type_code = p_reval_asset_params(1).book_type_code
1450: AND b.asset_id = p_reval_asset_params(1).asset_id
1451: AND b.transaction_header_id_out IS NULL;