APPS.OKE_CONTRACT_PUB dependencies on OKE_K_HEADERS

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

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

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

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

Line 3935: FROM OKE_K_HEADERS

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

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

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