APPS.OKL_CREATE_KLE_PVT dependencies on FA_ADDITIONS_B

Line 14053: from fa_additions_b fab,

14049: --bug# 3783518 : is asset number equal in case of rebook
14050: cursor l_chk_rbk_ast(p_cle_id in number, p_chr_id in number, p_asset_id number) is
14051: select 'N' change_flag,
14052: chrb.orig_system_source_code
14053: from fa_additions_b fab,
14054: okl_txl_assets_b txlb,
14055: okc_k_lines_b fa_cleb,
14056: okc_line_styles_b fa_lseb,
14057: okc_k_headers_b chrb

Line 16425: from fa_additions_b

16421:
16422: --cursor to get asset id from fa
16423: cursor l_fab_csr (p_asset_number in varchar2) is
16424: select asset_id
16425: from fa_additions_b
16426: where asset_number = p_Asset_number;
16427:
16428: l_asset_id fa_additions_b.asset_id%TYPE;
16429:

Line 16428: l_asset_id fa_additions_b.asset_id%TYPE;

16424: select asset_id
16425: from fa_additions_b
16426: where asset_number = p_Asset_number;
16427:
16428: l_asset_id fa_additions_b.asset_id%TYPE;
16429:
16430: --cursor to check if contract has re-lease assets
16431: --Bug# 15992711 : The re-leased flag is no longer checked at contract header
16432: -- but needs to be validated at contract line