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 2869: FROM fa_additions a

2865: FROM OKX_ASSET_LINES_V
2866: WHERE asset_number = p_asset_number; --); */
2867: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
2868: SELECT 1
2869: FROM fa_additions a
2870: WHERE a.asset_number = p_asset_number
2871: and exists
2872: (
2873: select 1 from okc_k_items b

Line 12092: from fa_additions fa

12088:
12089: --cursor to find whether unprocessed off lease transaction exists
12090: cursor l_off_lease_csr (p_asset_id in number) is
12091: select 'Y'
12092: from fa_additions fa
12093: where fa.asset_id = p_asset_id
12094: and exists
12095: (select '1'
12096: from okl_trx_assets h,

Line 12728: from fa_additions

12724:
12725: --cursor to get asset number
12726: cursor l_Asset_no_csr(p_asset_id in number) is
12727: select asset_number
12728: from fa_additions
12729: where asset_id = p_asset_id;
12730:
12731: l_asset_number fa_additions.asset_number%TYPE;
12732: l_mg_txd_id okl_txd_assets_b.id%TYPE;

Line 12731: l_asset_number fa_additions.asset_number%TYPE;

12727: select asset_number
12728: from fa_additions
12729: where asset_id = p_asset_id;
12730:
12731: l_asset_number fa_additions.asset_number%TYPE;
12732: l_mg_txd_id okl_txd_assets_b.id%TYPE;
12733: --Bug# 3631094
12734:
12735: --Bug# 3783518 :

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',