APPS.FA_RECLASS_UTIL_PVT dependencies on FA_BOOK_CONTROLS

Line 65: FROM FA_CATEGORY_BOOKS cb, FA_BOOKS bk, fa_book_controls bc

61:
62: -- Make sure the new category is defined in all the books the asset belongs to.
63: -- Get the number of books in which the new category is defined for the asset.
64: SELECT count(*) INTO l_count1
65: FROM FA_CATEGORY_BOOKS cb, FA_BOOKS bk, fa_book_controls bc
66: WHERE bk.asset_id = p_asset_id
67: AND bk.date_ineffective IS NULL
68: AND bk.book_type_code = cb.book_type_code
69: AND cb.category_id = p_new_category_id

Line 75: FROM FA_BOOKS bk, FA_BOOK_CONTROLS bc

71: AND nvl(bc.date_ineffective,sysdate) >= sysdate;
72:
73: -- Get the total number of books the asset belongs to.
74: SELECT count(*) INTO l_count2
75: FROM FA_BOOKS bk, FA_BOOK_CONTROLS bc
76: WHERE bk.asset_id = p_asset_id
77: AND bk.date_ineffective IS NULL
78: AND bk.book_type_code = bc.book_type_code
79: AND nvl(bc.date_ineffective,sysdate) >= sysdate;

Line 305: FA_BOOK_CONTROLS BC

301: BEGIN
302: SELECT count(1)
303: INTO v_count
304: FROM FA_BOOKS BK,
305: FA_BOOK_CONTROLS BC
306: WHERE BK.ASSET_ID = p_asset_id AND
307: BK.PERIOD_COUNTER_FULLY_RETIRED IS NOT NULL AND
308: BK.DATE_INEFFECTIVE IS NULL AND
309: BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE AND

Line 353: FA_BOOK_CONTROLS BC,

349: select count(1)
350: into v_is_prior_period
351: FA_DEPRN_PERIODS DP_NOW,
352: FA_DEPRN_PERIODS DP,
353: FA_BOOK_CONTROLS BC,
354: FA_TRANSACTION_HEADERS TH
355: WHERE
356: TH.ASSET_ID = p_asset_id AND
357: TH.TRANSACTION_TYPE_CODE = DECODE(BC.BOOK_CLASS,'CORPORATE',

Line 486: SELECT 'x' FROM FA_BOOK_CONTROLS

482:
483: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.validate_adjustment';
484:
485: CURSOR check_mass_change_allowed IS
486: SELECT 'x' FROM FA_BOOK_CONTROLS
487: WHERE book_type_code = p_book_type_code AND allow_mass_changes = 'NO'
488: AND p_mr_req_id <> -1;
489: CURSOR check_prior_amort IS
490: SELECT 'x' FROM FA_BOOKS

Line 497: SELECT 'x' FROM FA_BOOK_CONTROLS

493: CURSOR check_cip IS
494: SELECT 'x' FROM FA_ADDITIONS
495: WHERE asset_id = p_asset_id AND asset_type = 'CIP';
496: CURSOR check_amort_allowed IS
497: SELECT 'x' FROM FA_BOOK_CONTROLS
498: WHERE book_type_code = p_book_type_code AND amortize_flag = 'NO';
499: CURSOR check_deprn IS
500: SELECT 'x' FROM FA_DEPRN_SUMMARY
501: WHERE book_type_code = p_book_type_code

Line 672: From fa_book_controls bc,

668: l_err_stage:= 'Get Chart of Accounts ID';
669: -- dbms_output.put_line(l_err_stage);
670: Select sob.chart_of_accounts_id
671: into h_chart_of_accounts_id
672: From fa_book_controls bc,
673: gl_sets_of_books sob
674: Where sob.set_of_books_id = bc.set_of_books_id
675: And bc.book_type_code = p_asset_hdr_rec.book_type_code;
676:

Line 804: from fa_book_controls bc,

800: dh.units_assigned,
801: dh.location_id,
802: dh.assigned_to,
803: ad.asset_number
804: from fa_book_controls bc,
805: fa_distribution_history dh,
806: fa_additions ad
807: where dh.asset_id = p_asset_hdr_rec.asset_id
808: and dh.book_type_code = bc.distribution_source_book