DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on FA_BOOKS

Line 7683: fa_books fab,

7679: fa_cleb.cle_id sla_source_kle_id,
7680: fbc.book_class
7681: --Bug# 6373605 end
7682: from
7683: fa_books fab,
7684: --Bug# 6373605 start
7685: fa_book_controls fbc,
7686: --Bug# 6373605 end
7687: okc_k_items fa_cim,

Line 9368: fa_books fab,

9364: fa.asset_category_id,
9365: fbc.book_class,
9366: fa.asset_number
9367: from fa_additions fa,
9368: fa_books fab,
9369: fa_book_controls fbc,
9370: okc_k_items cim,
9371: okc_k_lines_b cleb,
9372: okc_line_styles_b lseb

Line 9544: l_rep_pdt_book fa_books.book_type_code%TYPE;

9540: and ffr.adjusted_rate = p_adj_rate);
9541:
9542: l_method_id fa_methods.method_id%TYPE;
9543:
9544: l_rep_pdt_book fa_books.book_type_code%TYPE;
9545:
9546:
9547: --cursor to get defaults for multi-GAAP book
9548: cursor l_defaults_csr (p_book in varchar2,

Line 9570: from fa_books fab,

9566: Cursor l_fa_csr (p_asset_number in varchar2,
9567: p_book in varchar2) is
9568: select fab.*,
9569: fa.asset_category_id
9570: from fa_books fab,
9571: fa_additions fa
9572: where fab.book_type_code = p_book
9573: and fab.asset_id = fa.asset_id
9574: and fa.asset_number = p_asset_number

Line 11177: l_rep_pdt_book fa_books.book_type_code%TYPE;

11173: txd.tax_book
11174: from okl_txd_Assets_b txd
11175: where txd.tal_id = p_tal_id;
11176:
11177: l_rep_pdt_book fa_books.book_type_code%TYPE;
11178:
11179: cursor l_capital_cost_csr(p_fin_cle_id in number) IS
11180: select kle_fin.capital_amount
11181: from okc_k_lines_b cleb_fin,