APPS.OKC_OKS_PUB dependencies on OKC_K_LINES_B

Line 38: FROM okc_k_lines_b lin

34: WHERE hdr.id=pty.chr_id
35: AND pty.rle_code='CUSTOMER'
36: AND pty.object1_id1= to_char(p_to_id)
37: AND hdr.id IN (SELECT DISTINCT (dnz_chr_id)
38: FROM okc_k_lines_b lin
39: WHERE upg_orig_system_ref = 'ORDER'
40: AND lse_id IN (14, 19)
41: AND pty.dnz_chr_id = lin.chr_id);
42:

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:

Line 248: from okc_k_lines_b

244:
245:
246: cursor get_subscr_toplines(l_chr_id number) is
247: select id
248: from okc_k_lines_b
249: where dnz_chr_id = l_chr_id and chr_id is not null
250: and lse_id = 46
251: and (date_terminated is null or date_terminated >= sysdate);
252:

Line 256: from okc_k_lines_b

252:
253: -- if it doensn't return anything then all sub lines are terminated.
254: cursor get_sub_lines(l_chr_id number) is
255: select id
256: from okc_k_lines_b
257: where dnz_chr_id = l_chr_id and cle_id is not null
258: and lse_id in (7, 8, 9, 10, 11, 13, 18, 25, 35)
259: and date_terminated is null;
260: