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 291: FA_BOOK_CONTROLS BC

287: BEGIN
288: SELECT count(1)
289: INTO v_count
290: FROM FA_BOOKS BK,
291: FA_BOOK_CONTROLS BC
292: WHERE BK.ASSET_ID = p_asset_id AND
293: BK.PERIOD_COUNTER_FULLY_RETIRED IS NOT NULL AND
294: BK.DATE_INEFFECTIVE IS NULL AND
295: BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE AND

Line 336: FA_BOOK_CONTROLS BC,

332: select count(1)
333: into v_is_prior_period
334: FA_DEPRN_PERIODS DP_NOW,
335: FA_DEPRN_PERIODS DP,
336: FA_BOOK_CONTROLS BC,
337: FA_TRANSACTION_HEADERS TH
338: WHERE
339: TH.ASSET_ID = p_asset_id AND
340: TH.TRANSACTION_TYPE_CODE = DECODE(BC.BOOK_CLASS,'CORPORATE',

Line 463: SELECT 'x' FROM FA_BOOK_CONTROLS

459:
460: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.validate_adjustment';
461:
462: CURSOR check_mass_change_allowed IS
463: SELECT 'x' FROM FA_BOOK_CONTROLS
464: WHERE book_type_code = p_book_type_code AND allow_mass_changes = 'NO'
465: AND p_mr_req_id <> -1;
466: CURSOR check_prior_amort IS
467: SELECT 'x' FROM FA_BOOKS

Line 474: SELECT 'x' FROM FA_BOOK_CONTROLS

470: CURSOR check_cip IS
471: SELECT 'x' FROM FA_ADDITIONS
472: WHERE asset_id = p_asset_id AND asset_type = 'CIP';
473: CURSOR check_amort_allowed IS
474: SELECT 'x' FROM FA_BOOK_CONTROLS
475: WHERE book_type_code = p_book_type_code AND amortize_flag = 'NO';
476: CURSOR check_deprn IS
477: SELECT 'x' FROM FA_DEPRN_SUMMARY
478: WHERE book_type_code = p_book_type_code

Line 639: From fa_book_controls bc,

635: l_err_stage:= 'Get Chart of Accounts ID';
636: -- dbms_output.put_line(l_err_stage);
637: Select sob.chart_of_accounts_id
638: into h_chart_of_accounts_id
639: From fa_book_controls bc,
640: gl_sets_of_books sob
641: Where sob.set_of_books_id = bc.set_of_books_id
642: And bc.book_type_code = p_asset_hdr_rec.book_type_code;
643:

Line 768: from fa_book_controls bc,

764: dh.units_assigned,
765: dh.location_id,
766: dh.assigned_to,
767: ad.asset_number
768: from fa_book_controls bc,
769: fa_distribution_history dh,
770: fa_additions ad
771: where dh.asset_id = p_asset_hdr_rec.asset_id
772: and dh.book_type_code = bc.distribution_source_book