DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on FA_BOOKS

Line 7408: fa_books fab,

7404: fa_cleb.cle_id sla_source_kle_id,
7405: fbc.book_class
7406: --Bug# 6373605 end
7407: from
7408: fa_books fab,
7409: --Bug# 6373605 start
7410: fa_book_controls fbc,
7411: --Bug# 6373605 end
7412: okc_k_items fa_cim,

Line 9093: fa_books fab,

9089: fa.asset_category_id,
9090: fbc.book_class,
9091: fa.asset_number
9092: from fa_additions fa,
9093: fa_books fab,
9094: fa_book_controls fbc,
9095: okc_k_items cim,
9096: okc_k_lines_b cleb,
9097: okc_line_styles_b lseb

Line 9269: l_rep_pdt_book fa_books.book_type_code%TYPE;

9265: and ffr.adjusted_rate = p_adj_rate);
9266:
9267: l_method_id fa_methods.method_id%TYPE;
9268:
9269: l_rep_pdt_book fa_books.book_type_code%TYPE;
9270:
9271:
9272: --cursor to get defaults for multi-GAAP book
9273: cursor l_defaults_csr (p_book in varchar2,

Line 9295: from fa_books fab,

9291: Cursor l_fa_csr (p_asset_number in varchar2,
9292: p_book in varchar2) is
9293: select fab.*,
9294: fa.asset_category_id
9295: from fa_books fab,
9296: fa_additions fa
9297: where fab.book_type_code = p_book
9298: and fab.asset_id = fa.asset_id
9299: and fa.asset_number = p_asset_number

Line 10902: l_rep_pdt_book fa_books.book_type_code%TYPE;

10898: txd.tax_book
10899: from okl_txd_Assets_b txd
10900: where txd.tal_id = p_tal_id;
10901:
10902: l_rep_pdt_book fa_books.book_type_code%TYPE;
10903:
10904: cursor l_capital_cost_csr(p_fin_cle_id in number) IS
10905: select kle_fin.capital_amount
10906: from okc_k_lines_b cleb_fin,