APPS.IGI_IAC_CATCHUP_PKG dependencies on FA_BOOK_CONTROLS

Line 140: FROM fa_book_controls

136: AND asset_id = p_asset_id);
137:
138: CURSOR c_get_deprn_calendar IS
139: SELECT deprn_calendar
140: FROM fa_book_controls
141: WHERE book_type_code like p_book_type_code;
142:
143: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS
144: SELECT number_per_fiscal_year

Line 600: FROM fa_book_controls

596: l_salvage_value_correction number ;
597:
598: CURSOR c_get_deprn_calendar IS
599: SELECT deprn_calendar
600: FROM fa_book_controls
601: WHERE book_type_code = p_asset_balance.book_type_code;
602:
603: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS
604: SELECT number_per_fiscal_year

Line 1530: FROM fa_books b, fa_book_controls c

1526: 0 pys_deprn_reserve,
1527: 0 deprn_amount,
1528: deprn_start_date,
1529: depreciate_flag
1530: FROM fa_books b, fa_book_controls c
1531: WHERE b.book_type_code = p_reval_asset_params(1).book_type_code
1532: AND c.book_type_code = p_reval_asset_params(1).book_type_code
1533: AND b.asset_id = p_reval_asset_params(1).asset_id
1534: AND b.transaction_header_id_out IS NULL;