APPS.OKC_OKS_PUB dependencies on OKC_STATUSES_B

Line 133: from okc_k_headers_b a, okc_statuses_b b

129: where id = p_chr_id;
130:
131: cursor get_source_status(l_chr_id number) is
132: select a.sts_code
133: from okc_k_headers_b a, okc_statuses_b b
134: where a.id = l_chr_id and a.sts_code = b.code
135: and b.ste_code in ('ACTIVE','EXPIRED','SIGNED');
136:
137: -- Gets all the sublines of the source contract.

Line 140: from okc_k_lines_b a, okc_statuses_b b

136:
137: -- Gets all the sublines of the source contract.
138: Cursor get_sublines(l_chr_id number) is
139: select a.id, a.lse_id
140: from okc_k_lines_b a, okc_statuses_b b
141: where a.cle_id is not null and a.dnz_chr_id = l_chr_id
142: and a.lse_id in (7,8,9,10,11,18,25,35) and a.sts_code = b.code --Bug 3453752
143: and b.ste_code in ('ACTIVE','EXPIRED','SIGNED');
144: