APPS.OKL_CREDIT_MEMO_PVT dependencies on OKC_K_HEADERS_B

Line 20: FROM okc_k_headers_b khr

16:
17:
18: CURSOR line_bill_to_csr(p_khr_id NUMBER, p_kle_id NUMBER) IS
19: SELECT cs.cust_acct_site_id --, cp.standard_terms payment_term_id
20: FROM okc_k_headers_b khr
21: , okx_cust_site_uses_v cs
22: , okc_k_lines_b cle
23: , hz_customer_profiles cp
24: WHERE khr.id = p_khr_id

Line 32: FROM okc_k_headers_b khr

28: AND cle.BILL_TO_SITE_USE_ID = cs.id1
29: AND khr.bill_to_site_use_id = cp.site_use_id(+)
30: UNION
31: SELECT cs.cust_acct_site_id --, cp.standard_terms payment_term_id
32: FROM okc_k_headers_b khr
33: , okc_k_lines_b cle
34: , okc_k_items item
35: , okc_k_lines_b linked_asset
36: , okx_cust_site_uses_v cs

Line 152: okc_k_headers_b chr

148: CURSOR c_synd IS
149: SELECT
150: 'SYNDICATION'
151: FROM
152: okc_k_headers_b chr
153: WHERE
154: EXISTS ( SELECT 'x' FROM okc_k_items cim
155: WHERE cim.object1_id1 = to_char(chr.id) AND
156: EXISTS ( SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse

Line 159: EXISTS ( SELECT 'x' FROM okc_k_headers_b chr2

155: WHERE cim.object1_id1 = to_char(chr.id) AND
156: EXISTS ( SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse
157: WHERE cle.lse_id = lse.id AND
158: lse.lty_code = 'SHARED' AND cle.id = cim.cle_id ) AND
159: EXISTS ( SELECT 'x' FROM okc_k_headers_b chr2
160: WHERE chr2.id = cim.dnz_chr_id AND
161: chr2.scs_code = 'SYNDICATION' AND
162: chr2.sts_code not in ('TERMINATED','ABANDONED') ) ) AND
163: chr.scs_code = 'LEASE' AND

Line 180: FROM okc_k_headers_b

176: -- so changed the queries as above.
177: -- rvaduri
178: CURSOR c_synd IS
179: SELECT scs_code
180: FROM okc_k_headers_b
181: WHERE scs_code = 'SYNDICATION'
182: AND id = p_khr_id;
183:
184: CURSOR c_fact IS