APPS.OKE_CONTRACT_PUB dependencies on OKE_K_DELIVERABLES_B

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

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

Line 3947: FROM OKE_K_DELIVERABLES_B DV

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

Line 3953: FROM OKE_K_DELIVERABLES_B DV

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

Line 3959: FROM OKE_K_DELIVERABLES_B DV

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

Line 4205: from oke_k_deliverables_b

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