APPS.OKE_CONTRACT_PUB dependencies on OKE_K_DELIVERABLES_B

Line 3271: and not exists (select 'x' from oke_k_deliverables_b where k_line_id = l.k_line_id)

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)
3271: and not exists (select 'x' from oke_k_deliverables_b where k_line_id = l.k_line_id)
3272: and exists (select 'x' from okc_assents a
3273: where a.opn_code = 'CREATE_DELV'
3274: and a.sts_code = l.status_code
3275: and a.scs_code = 'PROJECT'

Line 3949: FROM OKE_K_DELIVERABLES_B DV

3945: AND ST.STE_CODE not in ( 'ENTERED','CANCELLED');
3946:
3947: CURSOR check_po IS
3948: SELECT 'x'
3949: FROM OKE_K_DELIVERABLES_B DV
3950: WHERE PO_REF_1 IS NOT NULL
3951: AND DV.K_HEADER_ID = p_chr_id;
3952:
3953: CURSOR check_mps IS

Line 3955: FROM OKE_K_DELIVERABLES_B DV

3951: AND DV.K_HEADER_ID = p_chr_id;
3952:
3953: CURSOR check_mps IS
3954: SELECT 'x'
3955: FROM OKE_K_DELIVERABLES_B DV
3956: WHERE MPS_TRANSACTION_ID IS NOT NULL
3957: AND DV.K_HEADER_ID = p_chr_id;
3958:
3959: CURSOR check_wsh IS

Line 3961: FROM OKE_K_DELIVERABLES_B DV

3957: AND DV.K_HEADER_ID = p_chr_id;
3958:
3959: CURSOR check_wsh IS
3960: SELECT 'x'
3961: FROM OKE_K_DELIVERABLES_B DV
3962: WHERE SHIPPING_REQUEST_ID IS NOT NULL
3963: AND DV.K_HEADER_ID = p_chr_id;
3964:
3965: CURSOR check_funding IS

Line 4207: from oke_k_deliverables_b

4203: and object_type = 'OKE_K_HEADER';
4204:
4205: cursor c_del is
4206: select deliverable_id
4207: from oke_k_deliverables_b
4208: where k_header_id = p_chr_id;
4209:
4210:
4211: BEGIN