DBA Data[Home] [Help]

APPS.FA_INS_ADJUST_PKG dependencies on FA_BOOKS

Line 172: -- Get the current FA_BOOKS.COST value

168: -- h_total_amount := adj_ptr.adjustment_amount;
169: h_total_amount := adjustment_amount;
170: elsif (adj_ptr.adjustment_type = 'COST' OR
171: adj_ptr.adjustment_type = 'CIP COST') then
172: -- Get the current FA_BOOKS.COST value
173: -- if (not fagetcc(X_cost =>h_current_cost) then
174: -- return FALSE;
175: -- end if;
176: -- h_total_amount := h_total_amount + h_current_cost;

Line 276: h_book FA_BOOKS.Book_Type_Code%TYPE;

272: ) return boolean is
273:
274: h_mesg_name varchar2(50);
275: h_asset_id number;
276: h_book FA_BOOKS.Book_Type_Code%TYPE;
277: h_cost number;
278:
279: BEGIN <>
280:

Line 287: FROM FA_BOOKS

283: h_mesg_name := 'FA_TFR_NO_BOOKS_ROW';
284:
285: SELECT cost
286: INTO h_cost
287: FROM FA_BOOKS
288: WHERE asset_id = h_asset_id
289: AND book_type_code = h_book
290: AND date_ineffective is null;
291:

Line 884: from fa_books

880: and distribution_id in (select distribution_id from fa_distribution_history where asset_id = adj_ptr.asset_id and book_type_code = adj_ptr.book_type_code and date_ineffective is null);
881:
882: select PERIOD_COUNTER_FULLY_RESERVED, cost, group_asset_id
883: into h_pd_fully_rsv,h_books_cost,h_group_asset_id
884: from fa_books
885: where asset_id = adj_ptr.asset_id
886: and book_type_code = adj_ptr.book_type_code
887: and date_ineffective is null;
888: if(h_adj_no_rows = 0) then