APPS.OKL_VERSION_PVT dependencies on OKC_K_LINES_V

Line 66: CURSOR c_get_fa_line_id(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

62: l_api_name CONSTANT VARCHAR2(30) := 'OKL_VERSION_CREATE_FA';
63: l_vfav_rec OKL_VERSION_FA_PUB.vfav_rec_type;
64: lx_vfav_rec OKL_VERSION_FA_PUB.vfav_rec_type;
65:
66: CURSOR c_get_fa_line_id(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
67: IS
68: SELECT cle.id,
69: cle.dnz_chr_id,
70: cim.object1_id1,

Line 76: okc_k_lines_v cle

72: FROM okc_subclass_top_line stl,
73: okc_line_styles_b lse2,
74: okc_line_styles_b lse1,
75: okc_k_items_v cim,
76: okc_k_lines_v cle
77: WHERE cle.dnz_chr_id = p_dnz_chr_id
78: AND cle.id = cim.cle_id
79: AND cim.dnz_chr_id = cle.dnz_chr_id
80: AND lse1.id = cle.lse_id

Line 291: CURSOR c_get_ib_line_id(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

287: l_api_name CONSTANT VARCHAR2(30) := 'OKL_VERSION_CREATE_IB';
288: l_vibv_rec OKL_VERSION_IB_PUB.vibv_rec_type;
289: lx_vibv_rec OKL_VERSION_IB_PUB.vibv_rec_type;
290:
291: CURSOR c_get_ib_line_id(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
292: IS
293: SELECT cle.id,
294: cle.dnz_chr_id,
295: cim.object1_id1,