APPS.OKL_CONTRACT_PVT dependencies on OKC_K_HEADERS_BH

Line 271: FROM okc_k_headers_bh chrh,

267:
268: --Cursor to check if the contract was ever booked
269: Cursor Ever_Booked_crs(p_cle_id IN Number) is
270: SELECT 'Y'
271: FROM okc_k_headers_bh chrh,
272: okc_k_headers_b chr,
273: okc_k_lines_b cle
274: WHERE chrh.contract_number = chr.contract_number
275: AND chr.ID = cle.dnz_chr_id

Line 497: FROM okc_k_headers_bh chrh,

493:
494: --Cursor to check if the contract was ever booked
495: Cursor Ever_Booked_csr(p_chr_id IN Number) is
496: SELECT 'Y'
497: FROM okc_k_headers_bh chrh,
498: okc_k_headers_b chr
499: WHERE chrh.contract_number = chr.contract_number
500: AND chr.ID = p_chr_id
501: AND chrh.sts_code = G_OKL_BOOKED_STS_CODE

Line 4276: FROM okc_k_headers_bh chrh,

4272: AND rownum < 2;
4273:
4274: CURSOR Ever_Booked_crs(p_id number) IS
4275: SELECT 'Y'
4276: FROM okc_k_headers_bh chrh,
4277: okc_k_headers_b chr
4278: WHERE chrh.contract_number = chr.contract_number
4279: AND chr.id = p_id
4280: AND chrh.sts_code = G_OKL_BOOKED_STS_CODE