APPS.OKL_CONTRACT_PVT dependencies on OKC_STATUSES_B

Line 1164: okc_statuses_b sts,

1160: CURSOR l_lnk_ast_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
1161: Select lnk.id
1162: From okc_k_lines_b lnk,
1163: okc_line_styles_b lnk_lse,
1164: okc_statuses_b sts,
1165: okc_k_items cim
1166: Where lnk.id = cim.cle_id
1167: and lnk.dnz_chr_id = cim.dnz_chr_id
1168: and lnk.lse_id = lnk_lse.id

Line 2901: okc_statuses_b sts

2897: --bug 4412923: Removed the status 'CANCELLED' from the cursor
2898: Cursor top_cle_csr (p_chr_id IN NUMBER) is
2899: SELECT cle.id
2900: From okc_k_lines_b cle,
2901: okc_statuses_b sts
2902: where cle.dnz_chr_id = cle.chr_id
2903: and cle.chr_id = p_chr_id
2904: and sts.code = cle.sts_code
2905: And sts.ste_code not in ('HOLD','EXPIRED','TERMINATED');

Line 2922: from okc_statuses_b sts

2918: From okc_k_lines_b cle
2919: connect by prior cle.id = cle.cle_id
2920: start with cle.id = p_cle_id
2921: and exists (select 1
2922: from okc_statuses_b sts
2923: where sts.code = cle.sts_code
2924: and sts.ste_code not in ('HOLD','EXPIRED','TERMINATED'));
2925:
2926: l_cle_id OKC_K_LINES_B.ID%TYPE;

Line 10730: from okc_statuses_b a,

10726: b.scs_code,
10727: b.currency_code,
10728: --Bug# 2857899
10729: nvl(b.template_yn,'N') template_yn
10730: from okc_statuses_b a,
10731: okc_k_headers_b b,
10732: okl_k_headers c,
10733: OKC_STATUSES_TL cst
10734: where b.id = c.id