APPS.IGI_IAC_PROJ_PKG dependencies on FA_BOOK_CONTROLS

Line 262: FROM fa_book_controls

258: -- To get deprn calendar
259: CURSOR c_get_calendar(n_book_type_code fa_books.book_type_code%TYPE)
260: IS
261: SELECT deprn_calendar
262: FROM fa_book_controls
263: WHERE book_type_code = n_book_type_code;
264:
265: -- To get the price index value for a given period
266: CURSOR c_get_price_index_value(n_book_code fa_books.book_type_code%TYPE,

Line 429: FROM fa_book_controls

425: -- Get deprn calendar
426: CURSOR c_get_calendar(n_book_code fa_books.book_type_code%TYPE)
427: IS
428: SELECT deprn_calendar
429: FROM fa_book_controls
430: WHERE book_type_code = n_book_code;
431:
432: l_num_per_period fa_calendar_types.number_per_fiscal_year%TYPE;
433: l_mod_value NUMBER;

Line 495: FROM fa_book_controls

491: IS
492: SELECT number_per_fiscal_year
493: FROM fa_calendar_types
494: WHERE calendar_type = (SELECT deprn_calendar
495: FROM fa_book_controls
496: WHERE book_type_code = n_book_code);
497:
498:
499: l_prd_rec_frm_ctr igi_iac_types.prd_rec;

Line 910: l_sob_id fa_book_controls.set_of_books_id%TYPE;

906: l_category_id igi_iac_projections.category_id%TYPE;
907: l_reval_period_num igi_iac_projections.revaluation_period%TYPE;
908: l_status igi_iac_projections.status%TYPE;
909:
910: l_sob_id fa_book_controls.set_of_books_id%TYPE;
911: l_get_asset_bal_rec c_get_asset_all%ROWTYPE;
912: l_asset_dpis_date fa_books.date_placed_in_service%TYPE;
913:
914: l_next_period_ctr igi_iac_projections.start_period_counter%TYPE := 0;

Line 1024: FROM fa_book_controls

1020:
1021: -- get the set of books id for the book
1022: SELECT set_of_books_id
1023: INTO l_sob_id
1024: FROM fa_book_controls
1025: WHERE book_type_code =l_book_type_code;
1026:
1027: -- Retrieve all the assets that qualify for the projection run
1028: IF (l_category_id IS NOT NULL) THEN