APPS.OKC_CONTRACT_DOCS_GRP dependencies on OKC_DOC_QA_LISTS

Line 2534: FROM OKC_LOOKUPS_V LOOKUPS, OKC_DOC_QA_LISTS QA

2530:
2531: SELECT LOOKUPS.meaning qa_name,
2532: nvl(qa.severity_flag,G_QA_STS_WARNING) severity_flag ,
2533: decode(LOOKUPS.enabled_flag,'N','N','Y',decode(qa.enable_qa_yn,'N','N','Y'),'Y') perform_qa
2534: FROM OKC_LOOKUPS_V LOOKUPS, OKC_DOC_QA_LISTS QA
2535: WHERE QA.DOCUMENT_TYPE(+)=p_doc_type
2536: AND QA.QA_CODE(+) = LOOKUPS.LOOKUP_CODE
2537: AND LOOKUPS.LOOKUP_TYPE = 'OKC_TERM_QA_LIST'
2538: AND LOOKUPS.LOOKUP_CODE='CHECK_PRIMARY_CONTRACT';