APPS.OKS_AUTH_UTIL_PVT dependencies on OKC_K_LINES_V

Line 4881: FROM OKS_K_LINES_V kln, OKC_K_LINES_V cle

4877: /** Get tax values for each line for given contract id **/
4878: CURSOR l_get_tot_tax(p_dnz_chr_id IN NUMBER)
4879: IS
4880: SELECT cle.id, SUM(kln.tax_amount)
4881: FROM OKS_K_LINES_V kln, OKC_K_LINES_V cle
4882: WHERE cle.dnz_chr_id = p_dnz_chr_id
4883: AND cle.cle_id IS NULL
4884: AND kln.cle_id = cle.id;
4885:

Line 4891: FROM OKS_K_LINES_V kln, OKC_K_LINES_V cle

4887: /*** Get sum of taxes at subline level **/
4888: CURSOR l_get_tot_tax_subline(p_dnz_chr_id IN NUMBER, p_cle_id IN NUMBER)
4889: IS
4890: SELECT MAX(kln.tax_amount)
4891: FROM OKS_K_LINES_V kln, OKC_K_LINES_V cle
4892: WHERE cle.dnz_chr_id = p_dnz_chr_id
4893: AND cle.cle_id = p_cle_id
4894: AND kln.cle_id = cle.id;
4895:

Line 8650: FROM okc_line_styles_v lsev, okc_k_lines_v clev

8646: FOR UPDATE OF price_negotiated NOWAIT;
8647:
8648: CURSOR c_line_name(cp_id IN NUMBER) IS
8649: SELECT substr(RTRIM(RTRIM(line_number) || ', ' || RTRIM(lsev.name) || ' ' || RTRIM(clev.name)), 1, 2000) line_name
8650: FROM okc_line_styles_v lsev, okc_k_lines_v clev
8651: WHERE lsev.id = clev.lse_id
8652: AND clev.id = cp_id;
8653:
8654: CURSOR c_k_hdr(cp_chr_id IN NUMBER) IS