APPS.IGI_IAC_TRANSFERS_PKG dependencies on FA_BOOK_CONTROLS

Line 946: FROM fa_book_controls

942: IS
943: SELECT (number_per_fiscal_year*c_fiscal_year)+1
944: FROM fa_calendar_types
945: WHERE calendar_type=(SELECT deprn_calendar
946: FROM fa_book_controls
947: WHERE book_type_code=p_asset_hdr_rec.book_type_code);
948:
949: -- Find the asset number for the asset_id (for exception messages) (keep)
950: CURSOR c_asset_num

Line 978: FA_BOOK_CONTROLS bc

974: p_transaction_header_id number)
975: IS
976: SELECT count(*) interco_count
977: FROM FA_ADJUSTMENTS adj,
978: FA_BOOK_CONTROLS bc
979: WHERE adj.book_type_code = p_book_type_code
980: AND adj.ASSET_ID = p_asset_id
981: AND adj.SOURCE_TYPE_CODE = 'TRANSFER'
982: AND adj.ADJUSTMENT_TYPE IN ('INTERCO AP','INTERCO AR')

Line 2421: FROM fa_book_controls

2417: /* Cursor to select asset data for asset header rec */
2418:
2419: CURSOR c_asset_data IS
2420: SELECT set_of_books_id
2421: FROM fa_book_controls
2422: WHERE book_type_code=p_book_type_code;
2423:
2424: l_trans_rec FA_API_TYPES.trans_rec_type;
2425: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;