APPS.IGI_IAC_TRANSFERS_PKG dependencies on FA_BOOK_CONTROLS

Line 1037: FROM fa_book_controls

1033: IS
1034: SELECT (number_per_fiscal_year*c_fiscal_year)+1
1035: FROM fa_calendar_types
1036: WHERE calendar_type=(SELECT deprn_calendar
1037: FROM fa_book_controls
1038: WHERE book_type_code=p_asset_hdr_rec.book_type_code);
1039:
1040: -- Find the asset number for the asset_id (for exception messages) (keep)
1041: CURSOR c_asset_num

Line 1069: FA_BOOK_CONTROLS bc

1065: p_transaction_header_id number)
1066: IS
1067: SELECT count(*) interco_count
1068: FROM FA_ADJUSTMENTS adj,
1069: FA_BOOK_CONTROLS bc
1070: WHERE adj.book_type_code = p_book_type_code
1071: AND adj.ASSET_ID = p_asset_id
1072: AND adj.SOURCE_TYPE_CODE = 'TRANSFER'
1073: AND adj.ADJUSTMENT_TYPE IN ('INTERCO AP','INTERCO AR')

Line 2660: FROM fa_book_controls

2656: /* Cursor to select asset data for asset header rec */
2657:
2658: CURSOR c_asset_data IS
2659: SELECT set_of_books_id
2660: FROM fa_book_controls
2661: WHERE book_type_code=p_book_type_code;
2662:
2663: l_trans_rec FA_API_TYPES.trans_rec_type;
2664: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;