APPS.OKS_AUTH_UTIL_PVT dependencies on OKC_K_LINES_V

Line 4341: FROM OKS_K_LINES_V kln, OKC_K_LINES_V cle

4337: /** Get tax values for each line for given contract id **/
4338: CURSOR l_get_tot_tax(p_dnz_chr_id IN NUMBER)
4339: IS
4340: SELECT cle.id, SUM(kln.tax_amount)
4341: FROM OKS_K_LINES_V kln, OKC_K_LINES_V cle
4342: WHERE cle.dnz_chr_id = p_dnz_chr_id
4343: AND cle.cle_id IS NULL
4344: AND kln.cle_id = cle.id;
4345:

Line 4351: FROM OKS_K_LINES_V kln, OKC_K_LINES_V cle

4347: /*** Get sum of taxes at subline level **/
4348: CURSOR l_get_tot_tax_subline(p_dnz_chr_id IN NUMBER, p_cle_id IN NUMBER)
4349: IS
4350: SELECT MAX(kln.tax_amount)
4351: FROM OKS_K_LINES_V kln, OKC_K_LINES_V cle
4352: WHERE cle.dnz_chr_id = p_dnz_chr_id
4353: AND cle.cle_id = p_cle_id
4354: AND kln.cle_id = cle.id;
4355:

Line 7968: FROM okc_line_styles_v lsev, okc_k_lines_v clev

7964: FOR UPDATE OF price_negotiated NOWAIT;
7965:
7966: CURSOR c_line_name(cp_id IN NUMBER) IS
7967: SELECT substr(RTRIM(RTRIM(line_number) || ', ' || RTRIM(lsev.name) || ' ' || RTRIM(clev.name)), 1, 2000) line_name
7968: FROM okc_line_styles_v lsev, okc_k_lines_v clev
7969: WHERE lsev.id = clev.lse_id
7970: AND clev.id = cp_id;
7971:
7972: CURSOR c_k_hdr(cp_chr_id IN NUMBER) IS