APPS.FA_TRANSFERS_PKG dependencies on FA_BOOKS

Line 34: fa_books bk

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
38: and nvl(bc.date_ineffective, sysdate+1) > sysdate

Line 102: if X_From_Block <> 'FA_BOOKS' /* no asset_id yet for tfr in */ then

98:
99: end if; /* if X_Transfer_In_PC < X_Current_PC */
100: end if; /* if X_From_Block = ASSET or ASSETS_FDR */
101: --
102: if X_From_Block <> 'FA_BOOKS' /* no asset_id yet for tfr in */ then
103: -- make sure units are in sync
104: select units into lv_ah_units
105: from fa_asset_history
106: where asset_id = X_Asset_Id

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 151: from fa_books

147: end if;
148: -- Asset already fully retired?
149: select count(*)
150: into lv_count
151: from fa_books
152: where asset_id = X_Asset_Id
153: and book_type_code = X_Book_Type_Code
154: and date_ineffective is null
155: and period_counter_fully_retired is not null;