APPS.OKC_REP_CLOSEOUT_PVT dependencies on OKC_DELIVERABLES

Line 865: SELECT DELIVERABLE_STATUS FROM okc_deliverables del, okc_rep_contracts_all orca

861:
862: contract_rec contract_csr%ROWTYPE;
863:
864: CURSOR c_del_status_csr IS
865: SELECT DELIVERABLE_STATUS FROM okc_deliverables del, okc_rep_contracts_all orca
866: WHERE del.BUSINESS_DOCUMENT_TYPE = orca.contract_type
867: AND del.BUSINESS_DOCUMENT_ID = orca.contract_id
868: AND del.BUSINESS_DOCUMENT_VERSION = orca.contract_version_num
869: AND contract_id = l_contract_id

Line 1771: FROM okc_deliverables

1767: l_return_status VARCHAR2(1);
1768:
1769: CURSOR del_cur IS
1770: SELECT *
1771: FROM okc_deliverables
1772: WHERE deliverable_id = l_deliverable_id;
1773:
1774: l_del_rec del_cur%ROWTYPE;
1775: l_api_name VARCHAR2(30);

Line 1800: FROM okc_deliverables del

1796: IF (l_del_rec.business_document_type = 'REP_CCC') THEN
1797:
1798: BEGIN
1799: SELECT 'N' INTO all_dels_completed
1800: FROM okc_deliverables del
1801: WHERE del.business_document_id = l_del_rec.business_document_id
1802: AND del.business_document_type = l_del_rec.business_document_type
1803: AND del.business_document_version = l_del_rec.business_document_version
1804: AND del.deliverable_status NOT IN ('COMPLETED', 'CANCELLED', 'FAILED_TO_PERFORM')

Line 2264: UPDATE okc_deliverables set EXTERNAL_PARTY_ID =

2260: --------------------------------------------------------
2261:
2262: --update supplier information on the individual Po Del
2263:
2264: UPDATE okc_deliverables set EXTERNAL_PARTY_ID =
2265: (SELECT PARTY_ID
2266: FROM okc_rep_contract_parties
2267: WHERE contract_id = l_target_contract_id
2268: AND PARTY_ROLE_CODE = 'SUPPLIER_ORG')

Line 2380: FROM okc_rep_contract_usages orcu, okc_deliverables del

2376: IS
2377:
2378: CURSOR c_get_tasks_exists_csr IS
2379: SELECT Count(deliverable_id)
2380: FROM okc_rep_contract_usages orcu, okc_deliverables del
2381: WHERE orcu.business_document_type = p_document_rec.business_document_type
2382: AND orcu.business_document_id = p_document_rec.business_document_id
2383: AND del.business_document_type = orcu.contract_type
2384: AND del.business_document_id = orcu.contract_id