APPS.OKL_CONTRACT_PVT dependencies on OKC_STATUSES_B

Line 1196: okc_statuses_b sts,

1192: CURSOR l_lnk_ast_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
1193: Select lnk.id
1194: From okc_k_lines_b lnk,
1195: okc_line_styles_b lnk_lse,
1196: okc_statuses_b sts,
1197: okc_k_items cim
1198: Where lnk.id = cim.cle_id
1199: and lnk.dnz_chr_id = cim.dnz_chr_id
1200: and lnk.lse_id = lnk_lse.id

Line 2980: okc_statuses_b sts

2976: --bug 4412923: Removed the status 'CANCELLED' from the cursor
2977: Cursor top_cle_csr (p_chr_id IN NUMBER) is
2978: SELECT cle.id
2979: From okc_k_lines_b cle,
2980: okc_statuses_b sts
2981: where cle.dnz_chr_id = cle.chr_id
2982: and cle.chr_id = p_chr_id
2983: and sts.code = cle.sts_code
2984: And sts.ste_code not in ('HOLD','EXPIRED','TERMINATED');

Line 3001: from okc_statuses_b sts

2997: From okc_k_lines_b cle
2998: connect by prior cle.id = cle.cle_id
2999: start with cle.id = p_cle_id
3000: and exists (select 1
3001: from okc_statuses_b sts
3002: where sts.code = cle.sts_code
3003: and sts.ste_code not in ('HOLD','EXPIRED','TERMINATED'));
3004:
3005: l_cle_id OKC_K_LINES_B.ID%TYPE;

Line 10832: from okc_statuses_b a,

10828: b.scs_code,
10829: b.currency_code,
10830: --Bug# 2857899
10831: nvl(b.template_yn,'N') template_yn
10832: from okc_statuses_b a,
10833: okc_k_headers_b b,
10834: okl_k_headers c,
10835: OKC_STATUSES_TL cst
10836: where b.id = c.id