APPS.OKS_AUTH_UTIL_PVT dependencies on OKS_K_HEADERS_B

Line 7102: FROM OKS_K_HEADERS_B

7098: l_total_tax hdrtax_cur%ROWTYPE;
7099:
7100: CURSOR Get_Header_details IS
7101: SELECT id, object_version_number
7102: FROM OKS_K_HEADERS_B
7103: WHERE chr_id = p_header_id ;
7104:
7105: l_get_hdr_details get_header_details%ROWTYPE;
7106:

Line 8661: oks_k_headers_b c, oks_k_lines_b d

8657: SUM(nvl(b.price_negotiated,0)) sum_tl_line_amt,
8658: nvl(c.tax_amount,0) hdr_tax_amt,
8659: SUM(nvl(d.tax_amount,0)) sum_tl_line_amt_tax
8660: FROM okc_k_headers_all_b a, okc_k_lines_b b,
8661: oks_k_headers_b c, oks_k_lines_b d
8662: WHERE a.id = cp_chr_id
8663: AND b.dnz_chr_id = a.id AND b.cle_id IS NULL
8664: AND d.dnz_chr_id = c.chr_id AND d.cle_id=b.id
8665: AND b.date_cancelled is null

Line 8677: oks_k_headers_b c

8673: 0 sum_tl_line_amt,
8674: nvl(c.tax_amount,0) hdr_tax_amt,
8675: 0 sum_tl_line_amt_tax
8676: FROM okc_k_headers_all_b a,
8677: oks_k_headers_b c
8678: WHERE a.id = cp_chr_id
8679: AND c.chr_id = a.id
8680: AND NOT EXISTS (SELECT 1 from okc_k_lines_b b
8681: WHERE b.dnz_chr_id = a.id

Line 8928: UPDATE oks_k_headers_b

8924: WHERE id = p_chr_id;
8925: END IF;
8926:
8927: IF (l_hdr_amt_tax <> l_tl_amt_tax) THEN
8928: UPDATE oks_k_headers_b
8929: SET tax_amount = l_tl_amt_tax
8930: where chr_id = p_chr_id;
8931: END IF;
8932:

Line 8985: UPDATE oks_k_headers_b

8981: WHERE id = p_chr_id;
8982: END IF;
8983:
8984: IF (l_hdr_amt_tax <> l_tl_amt_tax) THEN
8985: UPDATE oks_k_headers_b
8986: SET tax_amount = l_tl_amt_tax
8987: where chr_id = p_chr_id;
8988: END IF;
8989:

Line 9528: FROM oks_k_headers_b

9524: SELECT ID, object_version_number FROM okc_k_lines_b WHERE ID = p_id;
9525:
9526: CURSOR l_oks_chr_csr(p_id NUMBER) IS
9527: SELECT ID, object_version_number
9528: FROM oks_k_headers_b
9529: WHERE chr_id = p_id;
9530:
9531: CURSOR l_oks_cle_csr(p_id NUMBER) IS
9532: SELECT ID, object_version_number