APPS.OKL_VP_COPY_CONTRACT_PVT dependencies on OKC_K_HEADERS_B

Line 147: FROM okc_k_headers_b

143:
144:
145: CURSOR c_template IS
146: SELECT template_yn
147: FROM okc_k_headers_b
148: WHERE id = p_chr_id;
149:
150: CURSOR invalid_template IS
151: SELECT count(*)

Line 152: FROM okc_k_headers_b

148: WHERE id = p_chr_id;
149:
150: CURSOR invalid_template IS
151: SELECT count(*)
152: FROM okc_k_headers_b
153: WHERE template_yn = 'Y'
154: AND sysdate between start_date and nvl(end_date, sysdate)
155: AND id = p_chr_id;
156: BEGIN

Line 229: FROM okc_k_headers_b

225: WHERE dnz_chr_id = p_from_chr_id;
226:
227: CURSOR l_chr_csr2(contract_no varchar2,contract_no_modifier varchar2) IS
228: SELECT 'x'
229: FROM okc_k_headers_b
230: WHERE contract_number = contract_no
231: AND contract_number_modifier = contract_no_modifier;
232:
233: CURSOR cur_contract_process(p_chr_id NUMBER) IS

Line 246: CURSOR c_get_rules_csr (cp_chr_id okc_k_headers_b.id%TYPE) IS

242: WHERE chr_id = p_chr_id
243: AND crs_id IS NULL;
244:
245: -- cursor for fetching the rules group.
246: CURSOR c_get_rules_csr (cp_chr_id okc_k_headers_b.id%TYPE) IS
247: SELECT rle.id,
248: rle.rgp_id,
249: rle.dnz_chr_id,
250: rle.std_template_yn,

Line 271: CURSOR c_get_agrmt_dates_csr(cp_chr_id okc_k_headers_b.id%TYPE) IS

267: AND rle.rgp_id = rlg.id;
268:
269:
270: -- abindal start --
271: CURSOR c_get_agrmt_dates_csr(cp_chr_id okc_k_headers_b.id%TYPE) IS
272: SELECT start_date
273: ,end_date
274: FROM okc_k_headers_b
275: WHERE id = cp_chr_id;

Line 274: FROM okc_k_headers_b

270: -- abindal start --
271: CURSOR c_get_agrmt_dates_csr(cp_chr_id okc_k_headers_b.id%TYPE) IS
272: SELECT start_date
273: ,end_date
274: FROM okc_k_headers_b
275: WHERE id = cp_chr_id;
276:
277: --abhsxen bug 6481995 start
278: CURSOR cur_k_party_roles(contract_id NUMBER) IS