APPS.OKL_AM_UTIL_PVT dependencies on FA_BOOK_CONTROLS

Line 4180: fa_book_controls fbc,

4176: CURSOR get_acc_deprn_csr (p_kle_id IN NUMBER, p_ter_date IN DATE) IS
4177: SELECT fds.deprn_reserve deprn_amt
4178: FROM fa_deprn_summary fds,
4179: fa_deprn_periods fdp,
4180: fa_book_controls fbc,
4181: fa_calendar_periods fcp,
4182: okc_k_items_v itm,
4183: okc_k_lines_b kle,
4184: okc_line_styles_v lse

Line 4204: fa_book_controls fbc,

4200: CURSOR get_acc_deprn1_csr (p_kle_id IN NUMBER) IS
4201: select fds.deprn_reserve deprn_amt
4202: from fa_deprn_summary fds,
4203: fa_deprn_periods fdp,
4204: fa_book_controls fbc,
4205: okc_k_items itm,
4206: okc_k_lines_b kle,
4207: okc_line_styles_b lse
4208: where fdp.book_type_code = fds.book_type_code

Line 4223: fa_book_controls fbc,

4219: -- get asset cost
4220: CURSOR get_asset_cost_csr (p_kle_id IN NUMBER) IS
4221: SELECT fab.original_cost
4222: FROM fa_books fab,
4223: fa_book_controls fbc,
4224: okc_k_items_v itm,
4225: okc_k_lines_b kle,
4226: okc_line_styles_v lse
4227: WHERE fbc.book_class = 'CORPORATE'

Line 4255: FROM okx_asset_lines_v o, fa_books a, fa_book_controls b

4251: -- rmunjulu 3735773
4252: -- get asset cost for corporate book (RMUNJULU)
4253: CURSOR get_corp_book_cost_csr (p_kle_id IN NUMBER) IS
4254: SELECT a.COST cost
4255: FROM okx_asset_lines_v o, fa_books a, fa_book_controls b
4256: WHERE o.parent_line_id = p_kle_id
4257: AND o.asset_id = a.asset_id
4258: AND a.book_type_code = b.book_type_code
4259: AND a.date_ineffective IS NULL

Line 4580: fa_book_controls fbc,

4576: CURSOR get_acc_deprn_csr (p_kle_id IN NUMBER, p_trn_date IN DATE) IS
4577: SELECT nvl(fds.deprn_reserve,0) deprn_amt
4578: FROM fa_deprn_summary fds,
4579: fa_deprn_periods fdp,
4580: fa_book_controls fbc,
4581: fa_calendar_periods fcp,
4582: okc_k_items_v itm,
4583: okc_k_lines_b kle,
4584: okc_line_styles_v lse

Line 4604: fa_book_controls fbc,

4600: CURSOR get_acc_deprn1_csr (p_kle_id IN NUMBER) IS
4601: SELECT nvl(fds.deprn_reserve,0) deprn_amt
4602: FROM fa_deprn_summary fds,
4603: fa_deprn_periods fdp,
4604: fa_book_controls fbc,
4605: okc_k_items itm,
4606: okc_k_lines_b kle,
4607: okc_line_styles_b lse
4608: WHERE fdp.book_type_code = fds.book_type_code

Line 4623: fa_book_controls fbc,

4619: -- get asset cost
4620: CURSOR get_asset_cost_csr (p_kle_id IN NUMBER) IS
4621: SELECT nvl(fab.cost,0) current_cost
4622: FROM fa_books fab,
4623: fa_book_controls fbc,
4624: okc_k_items_v itm,
4625: okc_k_lines_b kle,
4626: okc_line_styles_v lse
4627: WHERE fbc.book_class = 'CORPORATE'

Line 5148: fa_book_controls fbc

5144:
5145: CURSOR get_book_type_code(p_ast_id IN NUMBER) IS
5146: SELECT fbc.book_type_code
5147: FROM fa_deprn_summary fds,
5148: fa_book_controls fbc
5149: WHERE fbc.book_class = 'CORPORATE'
5150: AND fds.book_type_code = fbc.book_type_code
5151: AND fds.asset_id = p_ast_id
5152: and rownum = 1;

Line 5159: l_book_type_code fa_book_controls.book_type_code%TYPE;

5155: SELECT CURRENT_UNITS
5156: FROM fa_additions
5157: WHERE asset_id = p_ast_id;
5158:
5159: l_book_type_code fa_book_controls.book_type_code%TYPE;
5160: rel_date DATE;
5161: l_units NUMBER := 0;
5162:
5163: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;