APPS.FA_GAINLOSS_UPD_PKG dependencies on FA_BOOKS

Line 295: | this retirement. The ITC_AMOUNT_ID in FA_BOOKS must not be |

291: /*==========================================================================*
292: | NAME fagitc |
293: | |
294: | FUNCTION This function calculates ITC_RECAPTURED (if necessary) for |
295: | this retirement. The ITC_AMOUNT_ID in FA_BOOKS must not be |
296: | null in order for ITC_RECAPTURED to be calculated. |
297: | |
298: | HISTORY 1/17/89 R Rumanang Created |
299: | 12/27/89 R RUmanang Fixed bug in itc recaptured.|

Line 4258: FA_BOOKS bk,

4254: INTO h_same_fy, h_depr_first_year_ret,
4255: h_dwacq, h_rate_source_rule
4256: FROM FA_FISCAL_YEAR fy1,
4257: FA_FISCAL_YEAR fy2,
4258: FA_BOOKS bk,
4259: FA_RETIREMENTS rt,
4260: FA_CONVENTION_TYPES ctype,
4261: FA_METHODS mt,
4262: FA_BOOK_CONTROLS bc

Line 5265: fa_books bks

5261: select fy.fiscal_year
5262: into l_first_fiscal_year
5263: from fa_fiscal_year fy,
5264: fa_book_controls bc,
5265: fa_books bks
5266: where bc.book_type_code = ret.book
5267: and bc.fiscal_year_name = fy.fiscal_year_name
5268: and bks.book_type_code = ret.book
5269: and bks.asset_id = ret.asset_id

Line 5433: FROM fa_books bk,

5429:
5430: BEGIN
5431: SELECT to_number (to_char (bk.prorate_date, 'J'))
5432: INTO h_dpis_pr_jdt
5433: FROM fa_books bk,
5434: fa_calendar_periods dcp
5435: WHERE bk.book_type_code = ret.book
5436: AND transaction_header_id_out is null
5437: AND asset_id = ret.asset_id

Line 6318: from fa_books

6314: and transaction_header_id_out is null;
6315:
6316: CURSOR c_get_cost is
6317: select cost
6318: from fa_books
6319: where asset_id = bk.group_asset_id
6320: and book_type_code = ret.book
6321: and date_ineffective is null;
6322:

Line 6471: from fa_books

6467: -- Fix for Bug 3441030
6468: l_prev_deprn_reserve := deprn_reserve;
6469: select adjusted_recoverable_cost
6470: into l_prev_adj_rec_cost
6471: from fa_books
6472: where transaction_header_id_out = ret.th_id_in;
6473:
6474: if (l_prev_deprn_reserve = l_prev_adj_rec_cost) then
6475: l_fully_rsvd_flag := TRUE;

Line 6478: from fa_books

6474: if (l_prev_deprn_reserve = l_prev_adj_rec_cost) then
6475: l_fully_rsvd_flag := TRUE;
6476: select adjusted_recoverable_cost
6477: into l_new_adj_rec_cost
6478: from fa_books
6479: where transaction_header_id_in = ret.th_id_in;
6480: l_final_rsv := l_new_adj_rec_cost;
6481: end if;
6482:

Line 7532: update fa_books_summary

7528: and book_type_code = ret.book
7529: and period_counter = cpd_ctr
7530: and set_of_books_id = ret.set_of_books_id;
7531: else
7532: update fa_books_summary
7533: set expense_adjustment_amount = nvl(expense_adjustment_amount, 0) + nvl(g_deprn_amt, 0)
7534: , deprn_amount = nvl(deprn_amount, 0) + nvl(g_deprn_amt, 0)
7535: , ytd_deprn = nvl(ytd_deprn, 0) + nvl(g_deprn_amt, 0)
7536: , reserve_adjustment_amount = nvl(reserve_adjustment_amount, 0) - nvl(g_deprn_amt, 0)