DBA Data[Home] [Help]

APPS.FA_DEFERRED_DEPRN_PKG dependencies on FA_BOOK_CONTROLS

Line 76: fa_book_controls_mrc_v corp_bc,

72: FA_ASSET_HISTORY AH,
73: FA_DEPRN_PERIODS_MRC_V DP,
74: fa_adjustments_mrc_v CORP_AJ,
75: fa_adjustments_mrc_v TAX_AJ,
76: fa_book_controls_mrc_v corp_bc,
77: fa_book_controls_mrc_v tax_bc
78: WHERE DH.Book_Type_Code = p_corp_book
79: AND CORP_BC.book_type_code = p_corp_book
80: AND TAX_BC.book_type_code = p_tax_book

Line 77: fa_book_controls_mrc_v tax_bc

73: FA_DEPRN_PERIODS_MRC_V DP,
74: fa_adjustments_mrc_v CORP_AJ,
75: fa_adjustments_mrc_v TAX_AJ,
76: fa_book_controls_mrc_v corp_bc,
77: fa_book_controls_mrc_v tax_bc
78: WHERE DH.Book_Type_Code = p_corp_book
79: AND CORP_BC.book_type_code = p_corp_book
80: AND TAX_BC.book_type_code = p_tax_book
81: AND CORP_DD.Book_Type_Code (+) = p_corp_book

Line 200: from fa_book_controls

196: -- The deferred deprn exp acct of primary book is the same as the
197: -- reporting book. No need to enable MRC
198: select deferred_deprn_expense_acct
199: into l_deferred_deprn_exp_acct
200: from fa_book_controls
201: where book_type_code = p_tax_book;
202:
203:
204: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 754: FROM fa_book_controls

750:
751: CURSOR C_BOOKS (p_book_type_code varchar2)IS
752: SELECT 0,
753: set_of_books_id
754: FROM fa_book_controls
755: WHERE book_type_code = p_book_type_code
756: UNION ALL
757: SELECT 1, bcm.set_of_books_id
758: FROM fa_book_controls bc,

Line 758: FROM fa_book_controls bc,

754: FROM fa_book_controls
755: WHERE book_type_code = p_book_type_code
756: UNION ALL
757: SELECT 1, bcm.set_of_books_id
758: FROM fa_book_controls bc,
759: fa_mc_book_controls bcm
760: WHERE bc.book_type_code = p_book_type_code
761: AND bc.mc_source_flag = 'Y'
762: AND bcm.book_type_code = bc.book_type_code