APPS.FA_TRANSFERS_PKG dependencies on FA_BOOK_CONTROLS

Line 33: from fa_book_controls bc,

29: if (X_From_Block = 'ASSETS_FDR' or X_From_Block = 'ASSET') then
30: begin
31: select bc.book_type_code
32: into X_Book_Type_Code
33: from fa_book_controls bc,
34: fa_books bk
35: where bk.asset_id = X_Asset_Id
36: and bk.book_type_code = bc.book_type_code
37: and bk.date_ineffective is null

Line 72: from fa_book_controls

68: and nvl(dp.period_close_date, sysdate);
69: --
70: select fiscal_year_name, current_fiscal_year
71: into lv_fiscal_year_name, lv_fiscal_year
72: from fa_book_controls
73: where book_type_code = X_Book_Type_Code;
74: --
75: if X_Transfer_In_PC < X_Current_PC then
76: -- used for trans_date_entered validation only

Line 124: from fa_books bk, fa_book_controls bc

120: end if;
121: --
122: select count(*)
123: into lv_count
124: from fa_books bk, fa_book_controls bc
125: where bk.asset_id = X_Asset_Id
126: and bk.date_ineffective is null
127: and bk.book_type_code = bc.book_type_code
128: and bc.book_class = 'BUDGET'

Line 169: fa_book_controls bc

165: select count(1)
166: into lv_count
167: from fa_transaction_headers th,
168: fa_deprn_periods dp,
169: fa_book_controls bc
170: where bc.book_class <> 'CORPORATE'
171: and bc.distribution_source_book = X_Book_Type_Code
172: and th.book_type_code = bc.book_type_code
173: and th.asset_id = X_Asset_Id

Line 194: from fa_book_controls

190: end if; /* if X_From_Block <> 'BOOKS' */
191: --
192: select accounting_flex_structure
193: into X_Acct_Flex_Num
194: from fa_book_controls
195: where book_type_code = X_Book_Type_Code;
196: EXCEPTION
197: WHEN Validation_Error THEN
198: FA_STANDARD_PKG.RAISE_ERROR