APPS.OKS_AUTH_UTIL_PVT dependencies on OKS_K_HEADERS_B

Line 6482: FROM OKS_K_HEADERS_B

6478: l_total_tax hdrtax_cur%ROWTYPE;
6479:
6480: CURSOR Get_Header_details IS
6481: SELECT id, object_version_number
6482: FROM OKS_K_HEADERS_B
6483: WHERE chr_id = p_header_id ;
6484:
6485: l_get_hdr_details get_header_details%ROWTYPE;
6486:

Line 7979: oks_k_headers_b c, oks_k_lines_b d

7975: SUM(nvl(b.price_negotiated,0)) sum_tl_line_amt,
7976: nvl(c.tax_amount,0) hdr_tax_amt,
7977: SUM(nvl(d.tax_amount,0)) sum_tl_line_amt_tax
7978: FROM okc_k_headers_all_b a, okc_k_lines_b b,
7979: oks_k_headers_b c, oks_k_lines_b d
7980: WHERE a.id = cp_chr_id
7981: AND b.dnz_chr_id = a.id AND b.cle_id IS NULL
7982: AND d.dnz_chr_id = c.chr_id AND d.cle_id=b.id
7983: AND b.date_cancelled is null

Line 8146: UPDATE oks_k_headers_b

8142: WHERE id = p_chr_id;
8143: END IF;
8144:
8145: IF (l_hdr_amt_tax <> l_tl_amt_tax) THEN
8146: UPDATE oks_k_headers_b
8147: SET tax_amount = l_tl_amt_tax
8148: where chr_id = p_chr_id;
8149: END IF;
8150: