APPS.OKL_SUBSIDY_POOL_AUTH_TRX_PVT dependencies on OKC_K_LINES_V

Line 212: FROM okc_k_lines_v clev_asst

208: AND cplb.dnz_chr_id = cp_chr_id;
209:
210: CURSOR c_get_asset_csr (cp_asset_id okc_k_lines_b.id%TYPE)IS
211: SELECT clev_asst.name asset_number
212: FROM okc_k_lines_v clev_asst
213: WHERE clev_asst.id = cp_asset_id;
214: lv_asset_number okc_k_lines_v.name%TYPE;
215:
216: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;

Line 214: lv_asset_number okc_k_lines_v.name%TYPE;

210: CURSOR c_get_asset_csr (cp_asset_id okc_k_lines_b.id%TYPE)IS
211: SELECT clev_asst.name asset_number
212: FROM okc_k_lines_v clev_asst
213: WHERE clev_asst.id = cp_asset_id;
214: lv_asset_number okc_k_lines_v.name%TYPE;
215:
216: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;
217: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
218: lv_subsidy_applic VARCHAR2(10);

Line 338: FROM okc_k_lines_v clev_asst

334: CURSOR c_get_asset_csr IS
335: SELECT clev_asst.name asset_number
336: ,clev_asst.start_date asset_start_date
337: ,clev_asst.currency_code
338: FROM okc_k_lines_v clev_asst
339: WHERE clev_asst.id = p_asset_id;
340: cv_get_asset_rec c_get_asset_csr%ROWTYPE;
341:
342: -- cursor to check if the contract has been originated from quote or lease application

Line 955: FROM okc_k_lines_v

951: -- cursor to get the asset number for pool transaction record
952: -- added for subsidy pools enhancement
953: CURSOR c_get_asst_number (cp_asset_id okc_k_lines_b.id%TYPE)IS
954: SELECT name asset_number
955: FROM okc_k_lines_v
956: WHERE id = cp_asset_id;
957: lv_asset_number okc_k_lines_v.name%TYPE;
958:
959: CURSOR c_get_orig_asst (cp_asset_id okc_k_lines_b.id%TYPE) IS

Line 957: lv_asset_number okc_k_lines_v.name%TYPE;

953: CURSOR c_get_asst_number (cp_asset_id okc_k_lines_b.id%TYPE)IS
954: SELECT name asset_number
955: FROM okc_k_lines_v
956: WHERE id = cp_asset_id;
957: lv_asset_number okc_k_lines_v.name%TYPE;
958:
959: CURSOR c_get_orig_asst (cp_asset_id okc_k_lines_b.id%TYPE) IS
960: SELECT orig_system_id1
961: FROM okc_k_lines_b