DBA Data[Home] [Help]

APPS.OKL_LA_SALES_TAX_PVT dependencies on OKC_LINE_STYLES_V

Line 722: OKC_LINE_STYLES_V lse

718:
719: CURSOR get_contract_lines(p_chr_id okc_k_headers_b.id%TYPE) IS
720: SELECT cle.id
721: FROM OKC_K_LINES_V cle,
722: OKC_LINE_STYLES_V lse
723: WHERE cle.lse_id = lse.id
724: AND lse.lty_code = 'FREE_FORM1'
725: AND lse.lse_type = 'TLS'
726: AND cle.dnz_chr_id = p_chr_id;

Line 6132: okc_line_styles_v sty,

6128: FROM
6129: okc_k_lines_b cleb,
6130: okc_k_lines_tl clet,
6131: okl_k_lines kle,
6132: okc_line_styles_v sty,
6133: okc_statuses_v sts
6134: WHERE cleb.lse_id = sty.id
6135: AND cleb.sts_code = sts.code
6136: AND sts.ste_code not in ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')

Line 7023: okc_line_styles_v lsev

7019: kle.fee_type
7020: FROM okc_k_lines_v clev,
7021: okl_k_lines kle,
7022: okc_statuses_b okcsts,
7023: okc_line_styles_v lsev
7024: WHERE clev.dnz_chr_id = p_chr_id
7025: AND clev.chr_id = p_chr_id
7026: AND kle.id = clev.id
7027: --Bug# 12807203