APPS.OKL_LA_SALES_TAX_PVT dependencies on OKC_STATUSES_B

Line 5782: okc_statuses_b sts

5778: SELECT cle.id,
5779: name
5780: FROM okc_k_lines_v cle,
5781: okc_line_styles_b sty,
5782: okc_statuses_b sts
5783: WHERE cle.lse_id = sty.id
5784: AND cle.dnz_chr_id = p_chr_id
5785: AND lty_code = 'FREE_FORM1'
5786: AND cle.sts_code = sts.code

Line 5842: okc_statuses_b sts

5838: SELECT COUNT(cleb.id)
5839: FROM okc_k_lines_b cleb,
5840: okl_k_lines kle,
5841: okc_line_styles_b sty,
5842: okc_statuses_b sts
5843: WHERE cleb.lse_id = sty.id
5844: AND sty.lty_code = 'FEE'
5845: AND cleb.sts_code = sts.code
5846: AND sts.ste_code not in ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')

Line 6476: okc_statuses_b okcsts,

6472: clev.name,
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

Line 6497: okc_statuses_b okcsts

6493: cleb.end_date,
6494: cleb.start_date
6495: FROM okc_k_lines_b cleb,
6496: okl_k_lines kle,
6497: okc_statuses_b okcsts
6498: WHERE cleb.dnz_chr_id = p_chr_id
6499: AND kle.id = cleb.id
6500: AND cleb.cle_id = p_fee_line_id
6501: AND okcsts.code = cleb.sts_code