APPS.OKL_PRICING_PVT dependencies on OKC_STATUSES_B

Line 1468: okc_statuses_b sts

1464: SELECT kle.ID,
1465: sts.STE_CODE,
1466: trunc(nvl(kle.DATE_TERMINATED, sysdate)) date_terminated
1467: FROM okl_k_lines_full_v kle,
1468: okc_statuses_b sts
1469: WHERE kle.id = p_kle_id
1470: and kle.dnz_chr_id = p_khr_id
1471: and sts.code = kle.sts_code
1472: and sts.ste_code not in ('HOLD', 'EXPIRED', 'CANCELLED');

Line 4625: okc_statuses_b sts

4621: kle.amount link_amount
4622: from okl_k_lines_full_v kle,
4623: okl_k_lines_full_v kle1,
4624: okc_line_styles_b lse,
4625: okc_statuses_b sts
4626: where KLE1.LSE_ID = LSE.ID
4627: and ((lse.lty_code = 'SOLD_SERVICE') OR (lse.lty_code = 'FEE'and kle1.fee_type ='PASSTHROUGH'))
4628: and kle.dnz_chr_id = chrId
4629: and kle1.dnz_chr_id = kle.dnz_chr_id

Line 5885: okc_statuses_b sts

5881: CURSOR c_kle IS
5882: select kle.id,
5883: kle.start_date
5884: from okl_k_lines_full_v kle,
5885: okc_statuses_b sts
5886: where kle.dnz_chr_id = p_khr_id
5887: and kle.id = p_kle_id
5888: and sts.code = kle.sts_code
5889: and sts.ste_code not in ('HOLD', 'EXPIRED', 'CANCELLED');

Line 7187: okc_statuses_b sts

7183: where Exists(
7184: select kle.id
7185: from okl_k_lines_full_v kle,
7186: okc_line_styles_b lse,
7187: okc_statuses_b sts
7188: where KLE.LSE_ID = LSE.ID
7189: and lse.lty_code = 'SUBSIDY'
7190: and kle.dnz_chr_id = p_khr_id
7191: and sts.code = kle.sts_code

Line 9733: okc_statuses_b sts

9729: where Exists(
9730: select kle.id
9731: from okl_k_lines_full_v kle,
9732: okc_line_styles_b lse,
9733: okc_statuses_b sts
9734: where KLE.LSE_ID = LSE.ID
9735: and lse.lty_code = 'SUBSIDY'
9736: and kle.dnz_chr_id = p_khr_id
9737: and sts.code = kle.sts_code