APPS.OKL_CREATE_KLE_PVT dependencies on FA_ADDITIONS_B

Line 13954: from fa_additions_b fab,

13950: --bug# 3783518 : is asset number equal in case of rebook
13951: cursor l_chk_rbk_ast(p_cle_id in number, p_chr_id in number, p_asset_id number) is
13952: select 'N' change_flag,
13953: chrb.orig_system_source_code
13954: from fa_additions_b fab,
13955: okl_txl_assets_b txlb,
13956: okc_k_lines_b fa_cleb,
13957: okc_line_styles_b fa_lseb,
13958: okc_k_headers_b chrb

Line 16287: from fa_additions_b

16283:
16284: --cursor to get asset id from fa
16285: cursor l_fab_csr (p_asset_number in varchar2) is
16286: select asset_id
16287: from fa_additions_b
16288: where asset_number = p_Asset_number;
16289:
16290: l_asset_id fa_additions_b.asset_id%TYPE;
16291:

Line 16290: l_asset_id fa_additions_b.asset_id%TYPE;

16286: select asset_id
16287: from fa_additions_b
16288: where asset_number = p_Asset_number;
16289:
16290: l_asset_id fa_additions_b.asset_id%TYPE;
16291:
16292: --cursor to check if contract has re-lease assets
16293: CURSOR l_chk_rel_ast_csr (p_chr_id IN NUMBER) IS
16294: SELECT 'Y',