APPS.OKL_LA_SALES_TAX_PVT dependencies on OKC_LINE_STYLES_V

Line 564: OKC_LINE_STYLES_V lse

560:
561: CURSOR get_contract_lines(p_chr_id okc_k_headers_b.id%TYPE) IS
562: SELECT cle.id
563: FROM OKC_K_LINES_V cle,
564: OKC_LINE_STYLES_V lse
565: WHERE cle.lse_id = lse.id
566: AND lse.lty_code = 'FREE_FORM1'
567: AND lse.lse_type = 'TLS'
568: AND cle.dnz_chr_id = p_chr_id;

Line 5736: okc_line_styles_v sty,

5732: FROM
5733: okc_k_lines_b cleb,
5734: okc_k_lines_tl clet,
5735: okl_k_lines kle,
5736: okc_line_styles_v sty,
5737: okc_statuses_v sts
5738: WHERE cleb.lse_id = sty.id
5739: AND cleb.sts_code = sts.code
5740: AND sts.ste_code not in ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')

Line 6477: okc_line_styles_v lsev

6473: lsev.name line_type
6474: FROM okc_k_lines_v clev,
6475: okl_k_lines kle,
6476: okc_statuses_b okcsts,
6477: okc_line_styles_v lsev
6478: WHERE clev.dnz_chr_id = p_chr_id
6479: AND clev.chr_id = p_chr_id
6480: AND kle.id = clev.id
6481: AND kle.fee_type = 'FINANCED'