APPS.OKE_CONTRACT_PUB dependencies on OKE_K_HEADERS

Line 3220: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k

3216: l.copies_required,
3217: l.cdrl_category,
3218: l.data_item_name,
3219: l.export_flag
3220: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k
3221: where h.id = p_id
3222: and l.header_id = p_id
3223: and h.id = k.k_header_id
3224: and not exists (select 'x' from okc_k_lines_b s where s.cle_id = l.k_line_id)

Line 3264: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k

3260: l.copies_required,
3261: l.cdrl_category,
3262: l.data_item_name,
3263: l.export_flag
3264: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k
3265: where h.id = p_id
3266: and l.header_id = p_id
3267: and h.id = k.k_header_id
3268: and not exists (select 'x' from okc_k_lines_b s where s.cle_id = l.k_line_id)

Line 3933: FROM OKE_K_HEADERS

3929: AND ALLOWED_YN = 'Y';
3930:
3931: CURSOR check_boa IS
3932: SELECT 'x'
3933: FROM OKE_K_HEADERS
3934: WHERE K_HEADER_ID = p_chr_id
3935: AND K_TYPE_CODE IN (SELECT K_TYPE_CODE FROM OKE_K_TYPES_B WHERE TYPE_CLASS_CODE='BOA')
3936: AND K_HEADER_ID IN (SELECT BOA_ID FROM OKE_K_HEADERS);
3937:

Line 3936: AND K_HEADER_ID IN (SELECT BOA_ID FROM OKE_K_HEADERS);

3932: SELECT 'x'
3933: FROM OKE_K_HEADERS
3934: WHERE K_HEADER_ID = p_chr_id
3935: AND K_TYPE_CODE IN (SELECT K_TYPE_CODE FROM OKE_K_TYPES_B WHERE TYPE_CLASS_CODE='BOA')
3936: AND K_HEADER_ID IN (SELECT BOA_ID FROM OKE_K_HEADERS);
3937:
3938: CURSOR check_sts IS
3939: SELECT 'x'
3940: FROM OKC_STATUSES_B ST, OKC_K_HEADERS_B KH