APPS.PO_CLOSEOUT_PVT dependencies on OKC_DELIVERABLES

Line 804: FROM okc_rep_contract_usages orcu, okc_deliverables del

800: x_return_status => x_result_type);
801:
802: /*SELECT Count(1)
803: INTO l_count
804: FROM okc_rep_contract_usages orcu, okc_deliverables del
805: WHERE orcu.business_document_type = l_contr_type
806: AND orcu.business_document_id = p_doc_id -- po_header_id
807: --AND orcu.business_document_version = l_rev_number revision_num
808: AND del.business_document_type = orcu.contract_type

Line 1809: FROM okc_rep_contract_usages orcu, okc_deliverables del

1805: FROM po_closeout_details
1806: WHERE closeout_doc_type = 'MASS'
1807: AND reference_doc_id = p_req_id
1808: AND NOT EXISTS (SELECT 'Tasks not available'
1809: FROM okc_rep_contract_usages orcu, okc_deliverables del
1810: WHERE orcu.business_document_type = 'PO_CLOSEOUT_SET'
1811: AND orcu.business_document_id = p_req_id
1812: AND del.business_document_type = orcu.contract_type
1813: AND del.business_document_id = orcu.contract_id