APPS.OKL_CREATE_KLE_PVT dependencies on FA_ADDITIONS

Line 226: FROM fa_additions a

222: WHERE asset_number = p_asset_number; --); */
223:
224: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
225: SELECT 1
226: FROM fa_additions a
227: WHERE a.asset_number = p_asset_number
228: and exists
229: (
230: select 1 from okc_k_items b

Line 2889: FROM fa_additions a

2885: FROM OKX_ASSET_LINES_V
2886: WHERE asset_number = p_asset_number; --); */
2887: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
2888: SELECT 1
2889: FROM fa_additions a
2890: WHERE a.asset_number = p_asset_number
2891: and exists
2892: (
2893: select 1 from okc_k_items b

Line 12177: from fa_additions fa

12173:
12174: --cursor to find whether unprocessed off lease transaction exists
12175: cursor l_off_lease_csr (p_asset_id in number) is
12176: select 'Y'
12177: from fa_additions fa
12178: where fa.asset_id = p_asset_id
12179: and exists
12180: (select '1'
12181: from okl_trx_assets h,

Line 12814: from fa_additions

12810:
12811: --cursor to get asset number
12812: cursor l_Asset_no_csr(p_asset_id in number) is
12813: select asset_number
12814: from fa_additions
12815: where asset_id = p_asset_id;
12816:
12817: l_asset_number fa_additions.asset_number%TYPE;
12818: l_mg_txd_id okl_txd_assets_b.id%TYPE;

Line 12817: l_asset_number fa_additions.asset_number%TYPE;

12813: select asset_number
12814: from fa_additions
12815: where asset_id = p_asset_id;
12816:
12817: l_asset_number fa_additions.asset_number%TYPE;
12818: l_mg_txd_id okl_txd_assets_b.id%TYPE;
12819: --Bug# 3631094
12820:
12821: --Bug# 3783518 :

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