APPS.OKC_XPRT_UTIL_PVT dependencies on OKC_XPRT_DOC_QUES_RESPONSE

Line 6915: WHERE EXISTS (SELECT 1 FROM okc_xprt_doc_ques_response WHERE doc_id = p_document_id AND doc_type = p_document_type AND response IS NOT NULL);

6911: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine
6912: --checking whther the document have any expert responses
6913: BEGIN
6914: SELECT 'Y' INTO l_has_responses FROM dual
6915: WHERE EXISTS (SELECT 1 FROM okc_xprt_doc_ques_response WHERE doc_id = p_document_id AND doc_type = p_document_type AND response IS NOT NULL);
6916: EXCEPTION
6917: WHEN NO_DATA_FOUND THEN
6918: NULL;
6919: END;

Line 9391: WHERE EXISTS (SELECT 1 FROM okc_xprt_doc_ques_response WHERE doc_id = p_document_id AND doc_type = p_document_type AND response IS NOT NULL);

9387:
9388: --checking whther the document have any expert responses
9389: BEGIN
9390: SELECT 'Y' INTO l_has_responses FROM dual
9391: WHERE EXISTS (SELECT 1 FROM okc_xprt_doc_ques_response WHERE doc_id = p_document_id AND doc_type = p_document_type AND response IS NOT NULL);
9392: EXCEPTION
9393: WHEN NO_DATA_FOUND THEN
9394: NULL;
9395: END;