APPS.OKC_TERMS_UTIL_GRP dependencies on OKC_DELIVERABLES

Line 882: AND EXISTS ( SELECT 'Y' FROM okc_deliverables

878: WHERE NOT EXISTS (SELECT 'Y' FROM OKC_TEMPLATE_USAGES
879: WHERE DOCUMENT_TYPE = p_doc_type
880: AND DOCUMENT_ID = p_doc_id
881: )
882: AND EXISTS ( SELECT 'Y' FROM okc_deliverables
883: WHERE business_document_type=p_doc_type
884: AND business_DOCUMENT_ID=p_doc_id
885:
886: );

Line 4640: FROM okc_deliverables

4636: IS
4637: CURSOR cur_get_del
4638: IS
4639: SELECT 'Y'
4640: FROM okc_deliverables
4641: WHERE business_document_type = p_document_type
4642: AND business_document_id = p_document_id
4643: AND business_document_version=Nvl(p_doc_version,-99);
4644: